Job Role:
We are seeking a highly skilled and experienced SQL DBA to join our team. As a SQL DBA, you will be responsible for maintaining, troubleshooting, installing, and developing enterprise-level MS SQL database systems.
About the Role:
This is a dynamic and challenging role that requires strong analytical and problem-solving skills. The successful candidate will have a degree in Computing or a related field and at least 2 years of experience in a high-transaction, 24/7 environment supporting both development and production databases within a busy business operation.
Key Responsibilities:
1. Provide day-to-day operational support
2. Capacity planning, monitoring, auditing, and database/application performance optimization
3. Proactively suggest and implement database and application patches and new releases
4. Take a key role in future system design and direction
5. Install and maintain MS SQL servers running the latest edition in an enterprise-level production environment
6. Proactively improve and troubleshoot system performance
7. Plan and execute backup and recovery of databases
8. Develop software solutions by studying information needs, conferring with users, studying systems flow, data usage, work processes, investigating problem areas, following the software development lifecycle, designing, developing, testing, debugging, and delivering new products and features
9. Develop, update, and apply procedures supporting company data security and integrity policies and regulations
10. Design, develop, and deploy reporting solutions
11. Configure, deploy, and maintain database servers
12. Guide the development team on efficient coding and best practices
13. Assist with effort estimates and project schedules
14. Enhance and maintain system functionality
15. Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, and code
16. Improve operations by conducting systems analysis, recommending changes in policies and procedures
17. Update job knowledge by studying state-of-the-art development tools, programming techniques, computing equipment, participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations
18. Protect operations by keeping information confidential
19. Provide information by collecting, analyzing, and summarizing development and service issues
20. Achieve engineering and organization mission by completing related results as needed
21. Cross-train with and support IT administrators
22. Complete some analytics and report development
23. Nice to Have: Knowledge of monitoring, optimizing, maintaining security controls, and troubleshooting cloud infrastructure, preferably AWS Experience designing, implementing, and managing AWS-based infrastructure using infrastructure as code tools such as CloudFormation or Terraform Tableau development experience SQL Development experience