Sr. Database Administrator

Job Req ID: 28906

Essential Duties and Responsibilities:

• Follow enterprise standards, procedures, physical data storage, maintenance, access, backup and recovery, documentation, security and best practice in a team environment.
• Responsible for the installation, update, configuration and production support for all SQL server database services and servers
• Provides SQL DBA support based on SQL monitoring and maintenance solutions, responds to SQL alerts, and provides on-call support.
• Works closely with application and IT teams to design and optimize all DB environments
• Performs advanced database administration activities including installation, configuration, monitoring, space management, database backup and recovery, and disaster recovery procedures.
• Performs installation, configuration, and maintenance for SQL server AlwaysOn Availability Group
• Performs database environment reviews and provides DB improvement solutions to application owners
• Provide HA and DR solutions for Dev, Test and productions environments
• Provide technical writing and detailed documentation on technology standards and procedures and make recommendations for optimization.
• Independently be able to provide performance measures of transactional database; identifying bottlenecks, disk analysis and other metrics to provide tunning recommendations.

Qualifications:

• Bachelor's degree with a minimum of 5 years of relevant experience, or equivalent combination of education and experience.
• Extensive knowledge of database internals, security, encryption, and performance optimization.
• Proficiency in T-SQL programming and complex query optimization.
• Experience with SQL Server installation, configuration, patching, migration, and HA/DR strategies.
• Strong understanding of MS SQL Server database technologies and architecture principles.
• Ability to provide 24x7 support for production environments, including emergency response for high-priority incidents.
• Experience with monitoring tools and proactive alert systems for access logs and error logs.
• Familiarity with SOX compliance standards and Segregation of Duties (SOD) policies.
• Experience with both on-premises and cloud environments.
• Strong problem-solving skills and the ability to work both independently and in team environments.