Senior Database Administrator / Senior Database Engineer

Roles & Responsibilities

JobTitle:

Senior Database Administrator/ Senior Database Engineer

What We Offer

. Salary Range:$8,000/month - $9,000/month

. Full family medicalbenefits will be provided

Qualification:

Degree or Diploma in ComputerScience, Information Technology, Information Systems, or a related discipline(equivalent professional certifications, e.g. Microsoft Certified: AzureDatabase Administrator Associate, will also be considered)

Experience:

3 - 5 Years

Full/Contract:

9-Month Contract

Skills/Domain:

3-5 years of hands-on experienceadministering and supporting Microsoft SQL Server and PostgreSQL databases inenterprise production environments

Job Responsibilities

. Administered,configured, and supported Microsoft SQL Server and PostgreSQL databases acrossDevelopment, UAT, Staging, Disaster Recovery, and Production environments.

. Installed, configured,upgraded, migrated, and maintained SQL Server and PostgreSQL databaseenvironments.

. Designed, built, andmaintained 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 changemanagement processes and minimizing downtime.

. Designed and maintaineddatabase architecture, schemas, tables, constraints, indexes, storedprocedures, functions, triggers, views, and other database objects.

. Led SQL Server versionupgrades (Standard Edition to Enterprise Edition), including planning, testing,migration, rollback planning, and production cutover.

. Configured andadministered Amazon RDS for PostgreSQL, including parameter groups, securityconfiguration, monitoring, backups, maintenance, and performance optimization.

. Configured and supportedSQL Server Transactional Replication for near real-time data synchronization.

. Administered SQL ServerFailover Cluster Instances (FCI), including shared storage management, clusterdrive configuration, failover testing, cluster monitoring, and highavailability support.

. Planned, implemented,and tested backup, recovery, disaster recovery (DR), and business continuitystrategies.

. Created and maintainedSQL Server Maintenance Plans, including automated backups, DBCC integritychecks, index maintenance, statistics updates, cleanup jobs, and scheduledmaintenance.

. Performed databaseperformance tuning, query optimization, execution plan analysis, indexoptimization, statistics management, blocking analysis, deadlocktroubleshooting, and capacity planning.

. Monitored databasehealth, storage utilization, replication, server performance, and proactivelyresolved production issues.

. Designed, developed, andsupported 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 executeddatabase migration projects, including schema migration, historical datamigration, and large-volume data loading.

. Performed SQL Serverpatching, cumulative updates (CU), security updates, and planned maintenanceactivities across Development, UAT, Staging, and Production environments.

. Provided staging,production, and weekend production support for mission-critical enterpriseapplications, ensuring high availability and business continuity.

. Collaborated withMicrosoft Level 4 Support Engineers to troubleshoot complex production issues,perform root cause analysis (RCA), and implement permanent solutions.

. Managed database useraccounts, logins, service accounts, roles, permissions, and Role-Based AccessControl (RBAC), ensuring compliance with security, audit, and User AccessManagement (UAM) policies.

. Conducted database riskassessments, audit compliance activities, security reviews, SSL certificateimplementation, database hardening, and vulnerability remediation.

. Reviewed, validated, andapproved database deployment scripts submitted by application teams, ensuringcompliance with security, performance, coding standards, and database bestpractices.

. Performed deploymentimpact analysis, release readiness assessments, rollback planning, andproduction implementation approvals.

. Prepared and maintaineddatabase architecture documents, technical specifications, deployment guides,operational runbooks, disaster recovery documentation, standard operatingprocedures (SOPs), and support documentation.

. Collaborated closelywith application development teams, infrastructure teams, DevOps engineers,cloud engineers, and vendors to deliver secure, scalable, and highly availabledatabase solutions.

. Worked with applicationteams to troubleshoot database-related issues, optimize SQL queries, andsupport application releases.

. Coordinated withinfrastructure teams for server provisioning, storage allocation, operatingsystem maintenance, SQL Server clustering, networking, SSL certificateimplementation, patching, and infrastructure upgrades.

. Participated inproduction change management, release management, incident management, problemmanagement, and post-implementation reviews.

. Mentored junior DBAs anddevelopers on SQL Server administration, database design, performance tuning,deployment standards, and operational best practices.

Requirements

. Microsoft SQL ServerAdministration

. PostgreSQLAdministration

. Amazon RDS forPostgreSQL

. Azure DevOps CI/CDPipelines

. SQL Server FailoverClustering (FCI)

. SQL Server TransactionalReplication

. 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 IntegrationServices (SSIS)

. ETL/ELT Development

. Python

. Shell Scripting

. SQL Server Agent

. Windows Task Scheduler

. Database Security &User Access Management (UAM)

. Role-Based AccessControl (RBAC)

. SSL CertificateManagement

. Risk Assessment &Audit Compliance

. Release & ChangeManagement

. Database Migration

. Technical Documentation

. Root Cause Analysis(RCA)

. Database Monitoring& Capacity Planning

. DevOps Collaboration

. Infrastructure &Application Support