Engineer, IT Systems - DBA Specialist

Responsibilities

Application/Database Administration

• Install, configure, and maintain SQL Server instances across development, testing, and production environments.
• Manage database performance, security, backups, and recovery plans.
• Support database design, development, and deployment for application projects.
• Collaborate with developers to optimize database schemas, queries, and stored procedures.
• Provide support for database-centric application troubleshooting and issue resolution

Cloud Database Management (Azure & AWS)

• Manage cloud-based database services, including Azure SQL Database, Azure Managed Instances, AWS RDS for SQL Server, and other cloud-native solutions.
• Implement and support hybrid database architectures and cloud migration strategies.
• Monitor and optimize cloud database performance and cost efficiency.

Performance Tuning

• Analyze and optimize SQL queries, indexes, and database structures to enhance database and application performance.
• Conduct regular performance monitoring and troubleshooting
• Troubleshoot performance bottlenecks at both the database and application level
• High Availability and Disaster Recovery
• Design and implement HA/DR solutions in cloud and hybrid environments, such as Azure Availability Zones, AWS Multi-AZ, and Always On.
• Test and maintain backup, recovery, and failover processes.
• Ensure database systems meet recovery time objectives (RTO) and recovery point objectives (RPO).
• Security and Compliance
• Implement database security best practices, including encryption, role-based access control, and threat protection.
• Ensure databases comply with regulatory and organizational security standards
• Automation, Scripting & DevOps Integration
• Develop automation scripts to streamline routine tasks using PowerShell, T-SQL, or other tools.
• Implement database monitoring and alerting systems.
• Integrate database management with DevOps pipelines (e.g., Azure DevOps, AWS CodePipeline, or Jenkins).
• Cloud Migration and Modernization
• Lead or participate in projects to migrate on-premises databases to Azure or AWS.
• Modernize existing databases by leveraging cloud-native features and tools.
• Monitoring and Reporting
• Use monitoring tools (e.g., Azure Monitor, AWS CloudWatch, SQL Server Profiler) to track database health and performance.
• Generate reports on database usage, capacity planning, and operational efficiency.
• Maintain up-to-date documentation for database configurations, processes, and procedures.
• Collaboration and Support
• Work closely with application development teams to design and optimize database architectures.
• Provide guidance and mentorship to junior DBAs and engineers.
• Upgrades and Migrations
• Plan and execute SQL Server upgrades, migrations, and patching.
• Evaluate new features and tools to enhance the database environment.
• Documentation & Mentorship
• Document processes, standards, and best practices for database and cloud environments.
• Mentor junior DBAs and application developers on database best practices.

Qualifications

• Bachelor’s Degree; Major: Computer Science, Information Technology. Experience in lieu of required education is acceptable. Master's Preferred
• 8 years of experience as an SQL Server DBA, focusing on application support.
• 3 years of experience managing cloud-based SQL Server environments on Azure and AWS
• Hands-on experience with multiple database technologies, including relational and NoSQL databases.
• Expertise in database performance tuning, backup and recovery, disaster recovery, and high availability architectures.
• Strong understanding of database security practices and regulatory compliance.
• Expertise with SQL Server (2016 and later) and cloud database services (Azure SQL, AWS RDS, etc.).
• Strong understanding of T-SQL, query performance tuning, and indexing strategies.
• Proficiency with cloud-native tools like Azure Data Factory, AWS Glue, and Data Migration Services.
• Hands-on experience with containerized database environments using Docker or Kubernetes is a plus.
• Familiarity with ETL processes, data warehousing, and BI tools is desirable.
• Experience with large heterogenous enterprise environments
• Developing and enforcing data retention policies to comply with regulatory standards like HIPAA.
• Leading or participating in database migration projects, including on-premises to cloud transitions or upgrades to newer technologies.
• Planning and executing regular disaster recovery drills to validate backup and restoration strategies.
• Incident management, including experience in diagnosing and resolving database-related incidents in a high-pressure environment, ensuring minimal downtime.
• Creating and maintaining detailed documentation for database systems, configurations, policies, and disaster recovery procedures.

Job-Related Skills/Competencies

• Works with leaders and team members to drive change and influence decision making by using objective metrics, comprehensive viewpoints, and strong partners
• Ability to influence decision making by preparing objective metrics, comprehensive viewpoints, and strong partnerships
• Uses logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems
• Identifies and accomplishes challenging objectives or personal goals. Works effectively with others to achieve goals.
• Looks for and takes advantage of opportunities. Maintains a high level of interest, enthusiasm
• Experience with Healthcare preferred