SQL DBA Engineer
Data-Core Systems Inc.
contract
Posted on:
Location Type: Hybrid
Location: Middletown • Pennsylvania • 🇺🇸 United States
Visit company websiteJob Level
SeniorLead
Tech Stack
AzureMongoDBPostgresRedisSQL
About the role
- Serve as the Primary SQL DBA responsible for database administration, configuration, maintenance, and performance optimization for SQL Server 2022 and 2019 in VM-based environments
- Manage and support Azure SQL SaaS databases, including backup, restoration, and high availability
- Administer Azure Redis Cache, ensuring optimal caching strategies for performance and scalability
- Deploy, configure, and monitor PostgreSQL Azure Flexible Servers for diverse data workloads
- Work with Cosmos DB (Document DB, Mongo DB APIs) for distributed data storage and management
- Collaborate with SAP teams on Datasphere integration for seamless data connectivity and analytics
- Develop and manage SQL stored procedures integrated within Azure DevOps (ADO) pipelines for CI/CD automation
- Oversee ADO release management, ensuring smooth and controlled deployments across environments
- Conduct proactive performance tuning, indexing, and query optimization
- Implement and maintain robust backup, disaster recovery, and security policies for database systems
Requirements
- 10–12 years of hands-on experience as a SQL Server DBA
- Expertise in VM-based SQL Server environments (SQL Server 2022, 2019)
- Proven experience with Azure SQL SaaS and Azure Redis Cache
- Strong proficiency with PostgreSQL Azure Flexible Server
- Working knowledge of Cosmos DB (Document DB and Mongo DB APIs)
- Experience integrating or managing data within SAP Datasphere
- Strong understanding of SQL stored procedures, T-SQL, and ADO pipeline automation
Benefits
- Health insurance
- Retirement plans
- Professional development