Job Description :
Interview: Phone and F2F Interview
Only USC, GC and EAD (GC, H4 or L2) - No H1-B or OPT candidates
Our client is looking for Database Administrator for SQL Server (Level III)
This position''s responsibilities include daily production support for the SQL Server database infrastructure. These database platforms are maintained on Windows Server Operating Systems on both physical and virtual footprints. Virtual servers are managed on V-Sphere using VMWare.
This position is also responsible for maintaining and managing the standards, documentation, backup and recovery, design, and implementation of the physical data storage, virtualization of databases, maintenance, patching, installation, capacity planning, access, security administration (vulnerability assessment and protection of data), performance and availability, data integrity, and troubleshooting of all assigned databases.
Basic Qualifications for Level III
Associate’s degree and a minimum of 6 years work experience as a SQL Server DBA in an enterprise data center environment; OR
High School diploma or GED and a minimum of 10 years work experience as a SQL Server DBA in an enterprise data center environment
Additional Requirements
Possess strong knowledge of SQL Server (all relevant and supported versions) running on a Windows OS platform.
Provide oversight, mentoring, and leadership to less-experienced staff.
Provide on-call support for production environment; conduct root cause analysis for issues.
Assist development teams with development, testing, tuning, and implementation of database applications.
Possess experience with virtualization of database platforms and environments.
Provide proactive monitoring of the database instances, and take preventive steps to ensure high availability and optimal performance.
Possess a working knowledge and use of COMMVAULT for backup and recovery.
Have strong experience with SQL Server Management Studio / SSAS / SSRS / SSIS / SQL Agent / SQL Engine / SQL Server Central Management Server, including setup and configuration.
Possess a working knowledge of Idera Diagnostic Manager and Solarwinds.
Strong technical abilities, quick study of new technology via on-the-job training, the intellect to resolve complex problems logically and methodically, and good judgment to involve and communicate with vendors, senior-level technicians, and management.
Have experience with setting up and maintaining an enterprise disaster recovery environment, using tools such as SQL Server Mirroring, SQL Server Always On, and SQL Server Log Shipping.
Ability to be on call 24x7 and participate in an on-call rotation.
Must demonstrate ability to work in a team-oriented environment and effectively communicate both orally and in writing with peers and customers.
Other Preferred Qualifications
Experience with SQL Server on Linux
Experience with Idera products Admin Toolkit, SQL Doctor, SQL Comparison
Experience with SQL Server Reporting Services, Analysis Services, Integration Services
Experience with virtualized databases on VMWare
Experience with Service Manager and ITIL processes
Certifications in SQL Server (MCSE)
PowerShell scripting languages
Banking/financial services industry experience
Must Have
· Associate’s degree or HS diploma + relevant experience
· Strong knowledge of SQL Server running on Windows OS
· Experience with virtualization of database platforms and environments
· Working knowledge and use of COMMVAULT for backup and recovery
· Strong experience with SQL Server Management Studio / SSAS / SSRS / SSIS / SQL Agent / SQL Engine / SQL Server Central Management Server, including setup and configuration
· Working knowledge of Idera Diagnostic Manager and Solarwinds
· Strong technical abilities, quick study of new technology via on-the-job training
· Experience with setting up and maintaining an enterprise disaster recovery environment
· Availability to participate on on-call rotation for 24x7 support