Database Operations Engineer coordinating migration to Azure and managing SQL databases. Enhancing operational efficiency and mentoring junior team members in a flexible work environment.
Responsibilities
Coordinate, plan and perform database migration activities transitioning from on-premises environments to Azure (PaaS & IaaS) and across Azure subscriptions
Lead complex fix or raised technical issues
Manage backups, recovery procedures, DBCC utilities, index maintenance job/database refresh
Recommend on procedure optimization, performance tuning & index tuning
Develop monitoring strategy / implementation pattern focused on SQL database instances in Azure cloud using New Relic
Build and maintain customized dashboard and alerts
Enhance operational efficiency through the design and adoption of automated tools and Generative AI solutions
Works closely with IT project managers, programmers, architects on initiatives
Planning, developing, testing and execution of Disaster recovery processes
Foster the culture of reliability approach by embarking on opportunities to implement self-healing database solutions
Maintain security, compliance, database hardening, encryption standards, audit, and access control frameworks
Oversee implementation and maintenance of database setup, installation, configuration & monitoring
Consult, guide & mentor junior team members
Participate in on-call support rotation including after-hours/weekend duties every 4 weeks
Requirements
Minimum 5 years+ of relevant technical experience
SQL server, Azure (IaaS & PaaS) cloud platforms
SSRS reporting server
Programming language: T-SQL for SQL server, PowerShell, Terraform & AZ CLI
Database monitoring: Foglight & NewRelic (or an equivalent monitoring tool)
Data Migration tools
Azure Geo Replication for High Availability
High Availability Solution-Clustering
Database backup/restore and disaster recovery
SQL server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance
Azure Active Directory & SQL authentication
Database hardening and security standards like TDE, SSL/TLS and auditing
Azure provisioning through automation tools such as IAC (Terraform), CI/CD i.e. Jenkins, Flyway, GitHub Actions
Cryptographic key management using Azure Key Vault (AKV)
Database health check, reports, and metrics
Benefits
health, dental, mental health, vision insurance
short- and long-term disability insurance
life and AD&D insurance coverage
adoption/surrogacy and wellness benefits
employee/family assistance plans
retirement savings plans including pension and global share ownership plan with employer matching contributions
financial education and counseling resources
generous paid time off including holidays, vacation, personal, and sick days
Principle Operations Specialist managing general labor responsibilities in grain operations. Overseeing truck and railcar preparation, delivery, and safety in Chinook, Montana.
Operations Supervisor managing daily warehouse operations and team supervision for logistics company. Ensuring training and coaching to foster team performance in Pryor, Oklahoma.
Operations Manager assisting Microbac leadership in improving lab efficiencies. Overseeing department leads and ensuring compliance with analytical testing requirements.
Analyst position focusing on fraud investigations at Dun & Bradstreet. Contributing to team efforts and utilizing AI - assisted tools for investigative efficiency.
Vice President, Evidence Strategy & Operations overseeing clinical research for Orthopedic team at Johnson & Johnson. Driving evidence generation and operations strategy to enhance innovative treatments.
Principal Associate leading access and enablement for Capital One’s Social Operations program. Driving operational aspects of social media campaigns and fostering collaboration across teams.
FinOps Intern assisting with cloud resource optimization and data analysis at Kushki. Involves developing dashboards and automating reporting processes.
Manager overseeing educational programs and team at The Tutorverse. Leading operational success while providing educational services to families and students.