Database Administrator (W2 Only) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Apptad ยท 1 day ago

Database Administrator (W2 Only)

Apptad is seeking a Database Administrator to manage and optimize various database systems. The role involves installing, configuring, and maintaining databases in both on-premise and AWS environments, while also collaborating with developers to enhance database performance and reliability.

ConsultingDevOpsInformation TechnologyProduct ManagementSoftware
badNo H1Bnote
Hiring Manager
Kumari Nisha Jyoti
linkedin

Responsibilities

Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments
Manage Replication solutions for each Database based on application requirement for proper HighAvailability
Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2)
Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation
Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes
Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments
Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance
Work closely with DevSecOps to ensure timely application of security patches and upgrades
Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime
Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders. Good with Shell Scripting or Python. Good with linux administration

Qualification

MySQLPostgreSQLAWSMongoDBRedisAnsibleCloudFormationShell ScriptingLinux AdministrationDatabase OptimizationDisaster RecoveryMonitoring SystemsCollaboration

Required

Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments
Manage Replication solutions for each Database based on application requirement for proper HighAvailability
Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2)
Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation
Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes
Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments
Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance
Work closely with DevSecOps to ensure timely application of security patches and upgrades
Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime
Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders
Good with Shell Scripting or Python
Good with linux administration

Company

Apptad

twittertwittertwitter
company-logo
Apptad offers strategic consulting, enterprise information management, and digital transformation services.

Funding

Current Stage
Late Stage

Leadership Team

A
Arbind Singh
Co-Founder and Chief Executive Officer (CEO)
linkedin
Company data provided by crunchbase