Position: Senior Operations Database Administrator
Duration: 3 month Contract for hire
W2 Pay Rate: Open
Responsibilities
• Support the production operational database components of clients primary Line-of-Business applications.
• Troubleshoot and resolve operational database alerts and issues such as performance degradation and job failures.
• Configure and maintain SQL Server Transactional replication across multiple subscribers
• Determine, implement, and manage database backup and recovery strategies, with focus on Database Mirroring and Log Shipping recovery.
• Deploy, configure, and troubleshoot SSIS packages running as a SQL Agent job
• Assist management with database and resource capacity planning.
• Administer and troubleshoot database security using proven methodologies.
• Assist development staff with the debugging and optimization of SQL queries and stored procedures.
• Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs.
• Design and manage database migration processes used to populate test databases
• Transact SQL and stored procedure development.
• Research problems and recommend corrective actions.
• Providing on call support to the IT customer base.
• Assist setting up database and instances in clustered environments.
• Assist setting up mirroring and log shipping,
• Other duties as assigned.
Qualifications
• Degree in computer science or related field, 8 or more years of relevant industry experience, 3 of which include working as a database administrator in a production environment.
• 3 or more years experience with MS SQL Server 7.0, MS SQL Server 2000, 2005, 2008, 2012 and at least one year experience with an additional RDMS.
• Very strong in troubleshooting and optimizing SQL Server hosts and code performance.
• Experience with MS SQL Server backup and recovery techniques in a clustered VLDB environment.
• Very strong understanding of SQL Server replication and associated technology.
• Experience supporting a mission critical application in an SaaS environment is a big plus
• Proven experience using Transact SQL.
• Familiarity with MS SQL Server Mirroring and log shipping.
• Familiarity with MS SQL Server SSIS configuration and deployment options
• Demonstrated experience in troubleshooting and resolving database problems.
• Understanding of database design practices, including database normalization concepts.
• Prefer background in Microsoft networking.
• Proven ability to work with limited supervision in a team environment.
• Excellent verbal and written communication skills.
• Proficiency with Powershell a big plus
• Linear troubleshooting ability
• The ability to work with developers a plus.
• An understanding of IIS 6 and IIS7 is a plus.
• Reporting and customer facing experience is a plus.
EEO/AA Employer
This position description is intended to describe the general nature and level of work being performed by people assigned to this position. It is not intended to be an extensive list of all responsibilities, activities and skills required of the position or people in the position.
Position: Senior Operations Database Administrator
Duration: 3 month Contract for hire
W2 Pay Rate: Open
Responsibilities
• Support the production operational database components of clients primary Line-of-Business applications.
• Troubleshoot and resolve operational database alerts and issues such as performance degradation and job failures.
• Configure and maintain SQL Server Transactional replication across multiple subscribers
• Determine, implement, and manage database backup and recovery strategies, with focus on Database Mirroring and Log Shipping recovery.
• Deploy, configure, and troubleshoot SSIS packages running as a SQL Agent job
• Assist management with database and resource capacity planning.
• Administer and troubleshoot database security using proven methodologies.
• Assist development staff with the debugging and optimization of SQL queries and stored procedures.
• Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs.
• Design and manage database migration processes used to populate test databases
• Transact SQL and stored procedure development.
• Research problems and recommend corrective actions.
• Providing on call support to the IT customer base.
• Assist setting up database and instances in clustered environments.
• Assist setting up mirroring and log shipping,
• Other duties as assigned.
Qualifications
• Degree in computer science or related field, 8 or more years of relevant industry experience, 3 of which include working as a database administrator in a production environment.
• 3 or more years experience with MS SQL Server 7.0, MS SQL Server 2000, 2005, 2008, 2012 and at least one year experience with an additional RDMS.
• Very strong in troubleshooting and optimizing SQL Server hosts and code performance.
• Experience with MS SQL Server backup and recovery techniques in a clustered VLDB environment.
• Very strong understanding of SQL Server replication and associated technology.
• Experience supporting a mission critical application in an SaaS environment is a big plus
• Proven experience using Transact SQL.
• Familiarity with MS SQL Server Mirroring and log shipping.
• Familiarity with MS SQL Server SSIS configuration and deployment options
• Demonstrated experience in troubleshooting and resolving database problems.
• Understanding of database design practices, including database normalization concepts.
• Prefer background in Microsoft networking.
• Proven ability to work with limited supervision in a team environment.
• Excellent verbal and written communication skills.
• Proficiency with Powershell a big plus
• Linear troubleshooting ability
• The ability to work with developers a plus.
• An understanding of IIS 6 and IIS7 is a plus.
• Reporting and customer facing experience is a plus.
EEO/AA Employer
This position description is intended to describe the general nature and level of work being performed by people assigned to this position. It is not intended to be an extensive list of all responsibilities, activities and skills required of the position or people in the position.