SQL server DBA

Global IT Investors Inc dba TechnoVal Alliance; Plano (TX); Presencial; USD 90.000 - 150.000; Jornada completa

Descripción de la vacante

Global IT Investors Inc dba TechnoVal Alliance in Plano, TX seeks an experienced SQL Server DBA to support a mission-critical banking environment. You will manage SQL Server databases, perform tuning, HA/DR, security, and ongoing maintenance.

The role requires hands-on expertise with Always On, backups, security, and compliance in BFSI settings; you will work with application, infra, and security teams and participate in 24x7 support.

Formación

• Strong experience as a SQL Server DBA.
• Hands-on with SQL Server 2016/2019/2022.
• Expertise in HA/DR, backups, and security.
• Experience in regulated BFSI environments.

Responsabilidades

• Install, configure, upgrade, patch, and maintain Microsoft SQL Server databases across environments.
• Perform database administration, monitoring, maintenance, backup, and recovery activities.
• Design, implement, and support HA and DR solutions using Always On AG, Failover Clustering, log shipping, and replication.
• Monitor SQL Server performance and resolve bottlenecks.
• Develop and maintain T-SQL scripts, stored procedures, jobs, and maintenance scripts.
• Manage SQL Server Agent jobs, alerts, operators, and maintenance tasks.
• Implement database security, logins, users, roles, permissions, encryption, and auditing.
• Support vulnerability remediation, security patching, and regulatory compliance.
• Collaborate with application, infrastructure, development, and security teams; participate in 24x7 production support.

Conocimientos

SQL Server

SQL Server 2016/2019/2022

T-SQL

Performance Tuning

HA/DR

Backup & Restore

PowerShell

Windows Server

Security & Compliance

Monitoring

Educación

Bachelor's degree in computer science/IT

Herramientas

Always On AG

Failover Clustering

SSIS

SQL Server Agent

Azure SQL

Descripción del empleo

Role Description

Role: SQL server DBA

Location: Plano, TX- Only Local candidate

Employment Type: Contract

Job Summary:

Industry: Banking / Financial Services

Job Summary

We are looking for an experienced SQL Server DBA to support a mission-critical banking/financial services environment. The ideal candidate will have strong hands-on experience with SQL Server database administration, performance tuning, high availability, disaster recovery, and database security. Experience working in regulated BFSI environments is highly preferred.

Key Responsibilities

• Install, configure, upgrade, patch, and maintain Microsoft SQL Server databases across development, QA, UAT, and production environments.


• Perform database administration, monitoring, maintenance, backup, and recovery activities.


• Design, implement, and support High Availability (HA) and Disaster Recovery (DR) solutions using Always On Availability Groups, Failover Cluster Instances, log shipping, and replication.


• Monitor SQL Server performance and proactively identify and resolve performance bottlenecks.


• Perform query optimization, indexing, execution plan analysis, and database tuning.


• Manage database backups, restores, recovery models, and disaster recovery procedures.


• Troubleshoot database connectivity, blocking, deadlocks, locking, and transaction-related issues.


• Develop and maintain T-SQL scripts, stored procedures, jobs, and maintenance scripts.


• Manage SQL Server Agent jobs, alerts, operators, and scheduled maintenance activities.


• Implement database security, including logins, users, roles, permissions, encryption, and auditing.


• Support database vulnerability remediation, security patching, and compliance requirements.


• Work closely with application, infrastructure, development, and security teams to resolve production issues.


• Participate in 24x7 production support, on-call rotations, and incident management as required.


• Assist with database migrations, upgrades, consolidations, and cloud/database modernization initiatives.


• Maintain documentation for database architecture, operational procedures, backup/restore strategies, and DR plans.


• Follow BFSI-specific security, audit, risk, and regulatory requirements.

Required Skills

• Strong experience as a SQL Server Database Administrator.


• Hands-on experience with SQL Server 2016/2019/2022.


• Strong knowledge of T-SQL, stored procedures, indexing, query optimization, and performance tuning.


• Experience with Always On Availability Groups, Failover Clustering, and HA/DR.


• Strong knowledge of backup, restore, recovery, and disaster recovery strategies.


• Experience with SQL Server security, permissions, encryption, auditing, and compliance.


• Strong troubleshooting and production support experience.


• Experience with SQL Server Agent, SSIS, monitoring, and automation.


• Knowledge of Windows Server and PowerShell scripting.


• Experience with database migration and upgrade projects.


• Strong communication and problem-solving skills.

Preferred / BFSI Experience

• Previous experience supporting banking, financial services, insurance, payments, lending, or capital markets applications.


• Understanding of PCI DSS, SOX, GLBA, SOC 2, or similar regulatory/compliance frameworks.


• Experience supporting high-volume, high-availability financial applications.


• Familiarity with ITIL processes, change management, incident management, and production support.


• Experience working in environments with strict data security, audit, and access-control requirements.


• Exposure to Azure SQL, SQL Managed Instance, or other cloud database platforms is a plus.

Education

Bachelor's degree in computer science, Information Technology, or a related field preferred.