Job Summary
primary MSSQL DBA
secondary MySQL/Oracle DBA
Responsibilities
1. Installation and configuration of MS SQL Server 2005 2008/2008 R2/2012 2014 2016 2019 2022
2. Migrating databases from SQL Server 2012/20014 to SQL Server 2016 2019 2022
3. Experience in MS SQL Server performance tuning along with SQL Profiler client/server connectivity query optimization Database Maintenance plans Database Consistency Checker using DBCC.
4. Experience in Production support on SQL Server Database Administrator and handling P1 and P2 tickets
5. Configuring and monitoring the Database Mirroring and Log Shipping replication clustering.
6. Working closely with IT to support physical database administration including performance management security installations upgrades
7. patches backup recovery space management performance tuning and capacity planning
8. Maintain backup and recovery process including disaster recovery performance and tuning of database and application
9. Managing database backup and recovery
10. Managing database security roles and profiles
11. Ensure data requirements have been identified design is fully normalized and database complies with industry best practices and strict security requirements
12. On-call support to maintain 7x24 coverage of the database environment Provides business with day-to-day stable and optimally designed tested and implemented database environment that
13. Minimize database downtime and manage parameters to provide fast query responses
14. Perform tests and evaluations regularly to ensure data security privacy and integrity
15. MCTS MCITP and/or MVP certifications a plus
16. Performing SQL DBA tasks in a team maintaining operations of enterprise data centers
17. Installing configuring and patching SQL Servers and Clusters
18. Troubleshooting and diagnosing database issues
19. Performance tuning
20. Database monitoring
21. Recommend and implement emerging database technologies.
22. Create and manage database reports visualizations and dashboards.
23. Create automation for repeating database tasks.
24. Strong command of SQL and SQL server tools
25. Monitor performance and setup alerts to avoid performance issues occurring on databases.
26. PowerShell and Unix shell scripting skills
27. Familiarity with SSAS SSIS SSRS
Certifications Required
Relevant certifications