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