Infrastructure Database Senior Engineer

Posting Title: Infrastructure Database Senior Engineer

Work Type: On-Site

Work Type Instructions: onsite

Job Location: Dallas, TX

Exact Company Location/Pin: 75241

Candidate Location Accepted by Client: Dallas, TX

Work Authorization - Visa Name: (USC) ;(GC)

Minimum Work Experience: 8 Years

Mandatory Skills: Azure SQL, Azure SQL MI, Azure SQL for PostgreSQL.

Good to Have Skills: MongoDB, DynamoDB, Azure Cosmos DB, Neo4j, Neptune etc

Contract Duration in Months: 6

Contract Duration: 6months

Email: (mentioned relevant email ID here)

Job Description:

Why you'll love this job.

As one diverse, high-performing team dedicated to technical excellence, you will focus relentlessly on delivering unrivaled digital products that drive a more reliable and profitable airline.

The Infrastructure Domain in Information Technology is dedicated to managing and maintaining the client/server hardware and software that underpins an organization's computing environment. This domain covers various responsibilities, from IT logistics to data center management. It supports various technologies, including VDI, API management, and infrastructure tools and processes to ensure business systems operate efficiently, reliably, and securely.

What you'll do.

As noted above, this list is intended to reflect the current job, but additional functions may not be referenced. Management will modify the job or require other tasks to be performed whenever it is deemed appropriate, observing any legal obligations, including any collective bargaining obligations.

Plan and implement database designs, including the creation and maintenance of cloud databases

Allocate resources such as Storage / Compute / Memory. Implement strategies for HA, Failover DR and Replication.

Fine-tune database systems to enhance performance, scalability, and reliability - including monitoring and optimizing database query performance, indexing etc.

Establish access and authentication controls to secure data, setup encryption, masking as required.

Manage and monitor performance, security, and availability of databases

Implement database backup and disaster recovery procedures

Work with development teams to optimize database usage and query performance

Coordinate and manage migration of databases to Azure platform

Perform capacity planning and demand forecasting for database systems

Identify and troubleshoot any database-related issues in a timely manner

Perform capacity planning and demand forecasting for database systems

Stay current with the latest Azure technologies, trends, and techniques

Minimum Qualifications- Education & Prior Job Experience

Bachelor's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering or related technical discipline, or equivalent experience/training

4 to 5 or more years of Database Administration experience. with any of the database management systems (Microsoft SQL Server, DB2 LUW, Oracle, PostgreSQL etc.).

4 to 5 or more years of experience working with large database / large scale projects.

4 to 5 years of experience with cloud-based database technologies (Azure SQL, Azure SQL MI, Azure SQL for PostgreSQL.

Knowledge of cloud computing concepts, virtualization, and infrastructure-as-a-service (IaaS) platforms.

Proficiency in SQL Server and Microsoft Azure cloud technologies.

Is a self-starter with the ability to work with little management supervision.

Has the ability to multi-task, be flexible and deal with interruptions and change.

Can co-ordinate the triage, identification and resolution of complex production and non-production issues

Proficient in SQL language, database principles, and data modeling

Must be willing to work varying shifts (Day, Night, Slit, or weekends)

Additional Skills or Prior Job Experience

1 to 3 years experience with NoSQL database systems (MongoDB, DynamoDB, Azure Cosmos DB, Neo4j, Neptune etc.).

Familiarity with Microsoft DevOps and PowerShell scripting.

Expertise in utilizing IaaS and PaaS services, including database services and Kubernetes.

Understanding of IP subnetting, Network Security Groups, routing, Azure Firewall, load balancing, DNS, and other networking concepts and protocols.

Experience with Azure SQL, PostgreSQL and other Azure data services

Knowledge of Power Shell or other scripting languages

Basic understanding of containers and virtualization technologies( Kubernettes, VMWare)

Skills, Licenses & Certifications

All candidates will need the following.

o Familiarity with workflow and ITSM tools and ticketing systems

o Excellent customer service skills with the ability to interface at all levels of the organization.

o Excellent verbal and written communication skills

o Ability to work independently and perform in a collaborative, team-based environment.

o Experience with monitoring and alerting tooling

o Experience with CICD pipelines / GitHub actions

o Experience with network connectivity and firewalls

o Basic understanding of leading cloud offerings Azure, Google Cloud Platform, AWS

Possession of Azure certifications in specialized areas preferred.

Language, Communication Skills, & Physical Abilities

Ability to effectively communicate verbally and written with all organizational levels.

Physical ability necessary to perform the position's essential functions safely and successfully, with or without any legally required reasonable accommodations that do not pose an undue hardship. Must be able to lift 35lbs.