URGENT NEED - Senior SQL Server DBA in White Plains, NY - Prefer LOCAL CANDIDATES - W2 Only (No C2C)!!
Location: White Plains, NY 10601 (Remote work allowed during pandemic; Must be able to work ONSITE later.)
Duration: 12 months + contract (high visibility of going long term or conversion into FTE)
Hired SQL Server Administrator will keep the database up and running smoothly at all times. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.
Job Functions & Responsibilities:
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Manage databases in cloud AWS and Azure platforms
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Required Skills & Experience:
Manage Microsoft SQL Server and other database systems in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
Monitors day to day operations and overall performance of SQL server environment and systems. Manages the environment using tools such as SSMS, Microsoft SQL Backup, Commvault and SCOM
Install, configure and support SQL Server environment including SSRS, SSIS, SSAS, Replication and AlwaysOn HA.
Work closely with other DBAs, Infrastructure team, application development team, business analysts and IT vendors to ensure high availability and proper functioning of databases.
Maintain database objects and perform database capacity planning, data modeling, data loads, troubleshooting, database backup and recovery
Perform best practices related to monitoring, security, and performance tuning (Operating System, SQL Server, Disk Utilization, TSQL queries).
Experience in designing, deploying, and maintaining SQL Server infrastructure on versions 2008R2/2012/2014/2016/2017/2019
Through knowledge of windows platforms 2008/2008R2/2012/2016/2019
Experience in Performance Tuning and Optimization using native monitoring and monitoring tools.
Experience in Upgrade/migration of new releases from Development to QA, UAT and Production including inbuilt custom and vendor applications with standard procedures.
Experience with the full Software Development Life Cycle (SDLC).
Through advanced knowledge of HA including Failover clustering, replication, Log Shipping and AlwaysOn.
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models with third party tools
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server, including Active Directory
MCTS, MCITP, and/or MVP certifications a plus