title: s. and select worldwide markets. wi-milwaukee
assurant is a premier provider of specialized insurance products and related services in north america and select worldwide markets, sr. sql server dba
other locations: mn-woodbury, ga-atlanta.000 employees worldwide and is headquartered in new york's financial district.www.assurant.com, assurant has approximately 14. the assurant business units provide debt protection administration; credit-related insurance; warranties and service contracts; pre-funded funeral insurance; lender-placed homeowners insurance; manufactured housing homeowners insurance; individual health and small employer group health insurance; group dental insurance; group disability insurance; and group life insurance.a fortune 500 company and a member of the s&p 500,
assurant, is traded on the new york stock exchange under the symbol aiz.
to learn more about our current opportunities and apply online, please visit:http://www.assurant.jobs
follow us on twitter!http://twitter.com/assurantcareers(@assurantcareers). color, disability, state, or local law, sexual orientation, religion, sex, age, national origin, all aspects of consideration for employment and employment with the company are governed on the basis of merit, competence and qualifications without regard to race, or any otehr category protected by federal, veteran status.net and/or java application development and knoweldge of ssas and/or ssis development
assurant is an equal employment opportunity employer.
the sql server dba will service in the installation, and ongoing supoprt of assurant's sql server infrastructure encompassing all non-production and production environments, audit, optimization, security, configuration.and assurant employee benefits -- partner with clients who are leaders in their industries and build leadership positions in a number of specialty insurance market segments in the u, assurant specialty property, the four key businesses -- assurant solutions, assurant health.transactional replication, and ssas infrastructure administration
extensive knowledge of performance optimization for both sql server configuration and sql code tuning using os performance monitors, windows clustering, and run books for the operational platform
is responsible for all maojr database compnoents of sql server and has strong knowledge of the varoius interreltaionships betewen maojr sytsem compnoents inclduing netwroking, and dissater recvoery techonlogy
is consdiered by peres to be a subejct matter exeprt knowlegdeable on major components supproted by the team as well as by other techincal support stfaf such that the seinor dba is able to opearte with little superivsion and minmial techincal guiadnce
has thoorugh knowledge of adminitsrative and techincal resoruces available and a demonstrated ability to use those resources for problem determination, index and statistics maintenance plans, and udp networking infrastructure
strong knowledge of multi-instance and multi-server automation techniques such as system scripting, cell level and database level encryption, and vendor tools
strong knowledge of san attached storage, storage, wait and queue system dmvs, tcp, and policy based management
knowledge of, and other technical issues related to the sql server components being administered
executes and provides feedback on the tactical architecture's implementation as defined by the team manager under the guidance of team roadmaps
minimum of 5 years conducting general database administration tasks such as database and database server implementations, product enhancements, backups, database mirroring, multi-master and multi-subscriber replication administration, monitoring, operating system, and query plan dmvs, creation of db authentication principals, and vendor tools
extensive knowledge of troubleshooting techniques using system logs, unattended execution, windows server 2003 and 2008, application code, sql server statistics, and system troubleshooting
at least 2 years administering database platform specific advanced features such as sql clustering, cluster, system and query performance tuning, database encryption, system troubleshooting, and other tasks as assigned or expected from dbas
participates in the on-call rotation for supporting the operational platform
executes project and internal initiative responsibilities as assigned or delegated
authors and maintains operational documentation, cluster logs, active directory authentication, and ip, log shipping, system metadata catalogs, and heterogeneous oledb and odbc data source integration
extensive knowledge of platform specific advanced database features such as sql clustering, ssis etl, event logs, best practices, backups, index, performance tuning, code deployments,
supports day to day operational duties for the database platform such as service requests and tickets, enhanced logging configurations for related subsystems, ssis infrastructure administration, server, authentication.assurant has approximately $27 billion in assets and $8 billion in annual revenue.