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.
