- Provide specifications for provisioning new MSSQL Servers and manage their installation and configuration to provide optimum results
- Plan database upgrades and patching to avoid operational risks by maintaining application support requirements.
- Ensure database backup strategies are meeting Recovery Point and Recovery Time Objectives Track space usage trends and ensure adequate capacity for future growth of database environments.
- Provide Subject matter expertise on database design and database performance issues. Research and recommend new database software in area of database security, database monitoring and database development.
- Oversee production release management processes for database code promotions for various business applications.
- Perform development and test data refreshes as per business needs.
- Control and apply database access permissions, privileges and controls to maintain database security as per organizational standards.
- Develop & document best practices for all aspects of MSSQL Server management, database development & Database operation and Security Involve in architecting and implementing DR solutions with Always On, SQL log shipping, DB Mirroring, Replication.
- Mentor DBAs and Application Developers, manage and facilitate interface throughout organization to provide database technical support, advice and problem resolution for database centric issues.
- Provide Subject matter expertise on database design and database performance issues. Research and recommend new database software in area of database security, database monitoring and database development.
- Collaborate between Infrastructure Teams and Application Development Teams for scalable, efficient databases applications.
- Monitor MSSQL Servers for transaction latency, blocking and deadlock issues, and provide guidance in preventing/avoiding these issues to application development teams.
- Work with external and internal auditors to improve security, and develop & implement database auditing process, participate in database compliance and security audits and publish needed reports to upper management
Minimum Education and/or Experience Requirements:
- Bachelor’s degree plus at least ten years related experience
- Experience as Database Administrator in SQL Server Environment
- Experience supporting database sizes about 200GB to 4TB in size
- Experience supporting multiple instances of SQL 2005-SQL 2019 in production environment with components including SSRS, SSIS, SSAS, Clusters.
- Experience with Database Management and database monitoring tools such as DMVs, PerfMon, Profiler, Extended Events, third party tools such as Spotlight, Foglight , Performance Analyzer, Redgate SQL Monitor, Idera Diagnostic Manager, Idera SQLSafe , Litespeed
- Experience designing and documenting processes and procedures, database migration plans, database upgrade plans as per business requirements.
- Experience in designing, configuring and maintaining High Availability and DR Solutions.
- PowerShell, C# or .NET Scripting is a plus
Required Knowledge, Skills and Abilities:
- Strong verbal and written communication skills.
- Must be detailed-oriented, results-driven, highly energetic and motivated.
- Able to communicate efficiently and effectively to technical and non-technical audiences.
- Must be highly organized, detail oriented, extremely responsive and able to prioritize a large number of tasks.
- Proficiency in tuning SQL Server including optimizing T-SQL Queries.
- Ability to identify areas of instability and deviations from best practices with database components.
- Proficiency in SQL Server Monitoring tools such as DPA.
- Ability to work independently and in a team environment.
- Enthusiastic about working in a fast-paced organization.
- Ability to provide guidance to team members to meet deadlines and objectives
- Strong commitment towards SDLC/Change Management Principles.
- Knowledge of data quality, data management and data testing strategies and practices.
- Experienced with SQL installation on standalone and cluster servers across multi-subnet environments
- AWS/Microsoft Azure Services, Virtualization, Storage Area Networks, Windows Server Administration.
- Travel may be required 5% of the time.