Senior Manager, AIO Innovation (1 year contract)

Senior Database Administrator / Senior Database Engineer

Key Responsibilities

• Administered, configured, and supported Microsoft SQL Server and PostgreSQL databases across Development, UAT, Staging, Disaster Recovery, and Production environments.
• Installed, configured, upgraded, migrated, and maintained SQL Server and PostgreSQL database environments.
• Designed, built, and maintained Azure DevOps CI/CD pipelines for end-to-end database deployments, including schema changes, stored procedures, functions, triggers, views, indexes, constraints, and rollback strategies.
• Planned, coordinated, and executed production database deployments while adhering to change management processes and minimizing downtime.
• Designed and maintained database architecture, schemas, tables, constraints, indexes, stored procedures, functions, triggers, views, and other database objects.
• Led SQL Server version upgrades (Standard Edition to Enterprise Edition), including planning, testing, migration, rollback planning, and production cutover.
• Configured and administered Amazon RDS for PostgreSQL, including parameter groups, security configuration, monitoring, backups, maintenance, and performance optimization.
• Configured and supported SQL Server Transactional Replication for near real-time data synchronization.
• Administered SQL Server Failover Cluster Instances (FCI), including shared storage management, cluster drive configuration, failover testing, cluster monitoring, and high availability support.
• Planned, implemented, and tested backup, recovery, disaster recovery (DR), and business continuity strategies.
• Created and maintained SQL Server Maintenance Plans, including automated backups, DBCC integrity checks, index maintenance, statistics updates, cleanup jobs, and scheduled maintenance.
• Performed database performance tuning, query optimization, execution plan analysis, index optimization, statistics management, blocking analysis, deadlock troubleshooting, and capacity planning.
• Monitored database health, storage utilization, replication, server performance, and proactively resolved production issues.
• Designed, developed, and supported end-to-end ETL/ELT data pipelines for batch processing using SQL, SSIS, Python, Shell scripting, SQL Server Agent, and Windows Task Scheduler.
• Planned and executed database migration projects, including schema migration, historical data migration, and large-volume data loading.
• Performed SQL Server patching, cumulative updates (CU), security updates, and planned maintenance activities across Development, UAT, Staging, and Production environments.
• Provided staging, production, and weekend production support for mission-critical enterprise applications, ensuring high availability and business continuity.
• Collaborated with Microsoft Level 4 Support Engineers to troubleshoot complex production issues, perform root cause analysis (RCA), and implement permanent solutions.
• Managed database user accounts, logins, service accounts, roles, permissions, and Role-Based Access Control (RBAC), ensuring compliance with security, audit, and User Access Management (UAM) policies.
• Conducted database risk assessments, audit compliance activities, security reviews, SSL certificate implementation, database hardening, and vulnerability remediation.
• Reviewed, validated, and approved database deployment scripts submitted by application teams, ensuring compliance with security, performance, coding standards, and database best practices.
• Performed deployment impact analysis, release readiness assessments, rollback planning, and production implementation approvals.
• Prepared and maintained database architecture documents, technical specifications, deployment guides, operational runbooks, disaster recovery documentation, standard operating procedures (SOPs), and support documentation.
• Collaborated closely with application development teams, infrastructure teams, DevOps engineers, cloud engineers, and vendors to deliver secure, scalable, and highly available database solutions.
• Worked with application teams to troubleshoot database-related issues, optimize SQL queries, and support application releases.
• Coordinated with infrastructure teams for server provisioning, storage allocation, operating system maintenance, SQL Server clustering, networking, SSL certificate implementation, patching, and infrastructure upgrades.
• Participated in production change management, release management, incident management, problem management, and post-implementation reviews.
• Mentored junior DBAs and developers on SQL Server administration, database design, performance tuning, deployment standards, and operational best practices.
  

Requirements

• Degree in Computer Science, Computer Engineering, Information Technology, Information Systems or a related discipline.

• 8-12+ years of IT experience, including 3-5+ years in a leadership or management role.
• Strong stakeholder management, communication, decision-making, analytical and problem-solving skills.
• Certifications in AWS/cloud architecture, Kubernetes or ITIL/service management are preferred.
  
  

Technical Skills

• Microsoft SQL Server Administration
• PostgreSQL Administration
• Amazon RDS for PostgreSQL
• Azure DevOps CI/CD Pipelines
• SQL Server Failover Clustering (FCI)
• SQL Server Transactional Replication
• High Availability & Disaster Recovery (HA/DR)
• Backup & Recovery
• Performance Tuning & Query Optimization
• Index Optimization & Execution Plan Analysis
• T-SQL Development (Stored Procedures, Functions, Triggers, Views)
• SQL Server Integration Services (SSIS)
• ETL/ELT Development
• Python
• Shell Scripting
• SQL Server Agent
• Windows Task Scheduler
• Database Security & User Access Management (UAM)
• Role-Based Access Control (RBAC)
• SSL Certificate Management
• Risk Assessment & Audit Compliance
• Release & Change Management
• Database Migration
• Technical Documentation
• Root Cause Analysis (RCA)
• Database Monitoring & Capacity Planning
• DevOps Collaboration
• Infrastructure & Application Support