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