SQL Database Admin
About The Position
The client is seeking a Database Administrator professional with extensive experience in various database management systems, including design, testing, implementation, maintenance, and administration across multiple platform environments. This role requires a strong understanding of MS T/SQL, MS SQL Server, SQL Server Reporting Services (SSRS), Azure Power BI, web application development, Azure Dev Ops, Visual Studio .NET, and cloud database platforms like Azure SQL Managed Instance, Azure SQL Database, and Azure Database for PostgreSQL. The position also involves ensuring data security aligns with regulatory requirements and supporting large-scale implementation projects. Proficiency in Microsoft Office Suite and Visio is expected, along with strong performance tuning, troubleshooting, and optimization skills for both on-premises and cloud database environments. The role will support high-volume transactional and analytical workloads and contribute to cloud cost management initiatives.
Requirements
- Bachelor of Science/Arts degree in Computer Science, Management Information Systems Degree, or a related field preferred.
- Minimum 8 years of experience working with various database management systems in database design, testing, implementation, maintenance, and administration of multiple platform environments.
- Experience with performing backup and recovery on database management systems, configure database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.
- Minimum 8 years of experience writing complex efficient queries, views, stored procedures, and user defined functions with MS T/SQL.
- Minimum 5 years of experience with MS SQL Server and SQL Server Reporting Services (SSRS) utilizing parameters, sub-reports, drill down technologies and subscriptions.
- Minimum 5 years of experience producing technical documentation related to requirements, specifications, traceability matrices, designs, or testing.
- Minimum 3 years of experience creating and maintaining reports in Azure Power BI.
- Minimum 3 years of experience developing with web applications.
- Minimum 2 years of experience working with Azure Dev Ops and Visual Studio .NET.
- Minimum 3 years of experience administering cloud database platforms, including Azure SQL Managed Instance, Azure SQL Database, and/or Azure Database for PostgreSQL.
- Expertise in aligning application strategies with data security standards and regulatory requirements.
- Proficiency with Microsoft Word, Excel and Visio.
- Demonstrated experience with large-scale implementation projects.
- Expert knowledge of relational database management systems and database architecture principles.
- Strong performance tuning and troubleshooting skills in complex database environments.
- Experience reducing query response times and improving application performance through database optimization techniques.
- Experience optimizing cloud database resource utilization and supporting cloud cost management initiatives.
- Ability to analyze complex database environments and recommend performance, scalability, availability, and optimization strategies.
- Experience with cloud database platforms, including Azure SQL Database and Azure Database for PostgreSQL.
- Experience supporting high-volume transactional and analytical database workloads.
- Experience with performance engineering and database tuning methodologies.
Responsibilities
- Design, test, implement, maintain, and administer various database management systems in multiple platform environments.
- Perform backup and recovery on database management systems.
- Configure database parameters and prototype designs against logical data models.
- Define data repository requirements, data dictionaries, and warehousing requirements.
- Write complex efficient queries, views, stored procedures, and user-defined functions with MS T/SQL.
- Utilize MS SQL Server and SQL Server Reporting Services (SSRS) with parameters, sub-reports, drill-down technologies, and subscriptions.
- Produce technical documentation related to requirements, specifications, traceability matrices, designs, or testing.
- Create and maintain reports in Azure Power BI.
- Develop with web applications.
- Administer cloud database platforms, including Azure SQL Managed Instance, Azure SQL Database, and/or Azure Database for PostgreSQL.
- Align application strategies with data security standards and regulatory requirements.
- Review documents, including requirements documents, testing plans, development plans, and architectural plans.
- Support large-scale implementation projects.
- Perform performance tuning and troubleshooting in complex database environments.
- Reduce query response times and improve application performance through database optimization techniques.
- Optimize cloud database resource utilization and support cloud cost management initiatives.
- Analyze complex database environments and recommend performance, scalability, availability, and optimization strategies.
- Support high-volume transactional and analytical database workloads.
- Apply performance engineering and database tuning methodologies.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
