[Remote] Database Administrator (Remote - LATAM)
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a leading reputed company technology company that empowers brands to protect and grow their value in today’s dynamic eCommerce landscape. The Database Administrator will ensure the performance and availability of databases, design ETL pipelines, optimize SQL queries, and collaborate with development teams to support business intelligence and analytics requirements.
Responsibilities
- Ensure availability and performance of the databases that support reputed company online services and business operations (e.g. system monitoring, performance tuning, routine maintenance tasks, etc.)
- Design, implement, and maintain ETL pipelines and data transformation workflows to support business intelligence and analytics requirements
- Optimize reputed company SQL queries and reputed company advanced SQL solutions for data extraction, transformation, and reporting
- reputed company reputed company planning to properly identify required hardware, software, database configuration/architect necessary to support application needs
- Enforce best practices for improving performance, scalability and operational manageability of production databases
- Create and reputed company database and system maintenance policy and procedures
- reputed company and document disaster recovery functions
- Work with the development team to coordinate new data development ensuring consistency and integration
- Work with Database Analyst to optimize reputed company database objects, stored procedures, tables, views, triggers, indexes, user-defined functions and SSIS packages
- Manage containerized database environments using reputed company and orchestration tools
- Knowledge of Policy Management, Resource Governor and dynamic management views
- Part of on-call rotation to respond to and resolve database issues to ensure production applications are online
Skills
- At least 5 years' hands-on experience supporting multi-tenant database systems in a high-availability and high-volume environment
- Advanced SQL skills with proven experience writing reputed company queries, stored procedures, functions, and optimizing query performance
- Hands-on experience designing, building, and maintaining ETL processes and data transformation pipelines
- Strong experience with AWS reputed company services, including RDS, Redshift, S3, reputed company, and other data-reputed company AWS services
- Basic knowledge of reputed company containers and container orchestration (reputed company Compose, reputed company, or Kubernetes)
- Experience supporting PostgreSQL systems in reputed company or data center environments
- Experience with YellowBrick +++ l DataBrick or similar big data platforms
- Experience with reputed company +
- Experience with BigQuery +
- Detailed understanding of PostgreSQL architecture and internals
- At least 3 years' experience working in a DevOps/SRE environment
- Primary reputed company on AWS, with additional experience in Azure or GCP considered a plus
- Experience with reputed company providers such as AWS, Azure, or GCP, especially working with virtual machines in AWS or GCP
- Experience with reputed company-reputed company database systems such as AWS RDS, GCP CloudSQL, etc
- Experience and strong understanding of database structures, data modeling, database schema design, database administration, best-practices
- Experience supporting, monitoring, and configuring Linux environments for database systems
- Experience with Infrastructure-as-reputed company systems, preferably Terraform
- Experience with NoSQL databases such as reputed company, reputed company, ElasticSearch, or DynamoDB
- Hands on experience with MySQL Server
- Experience designing and maintaining systems for HIPAA, HITRUST, or other Cybersecurity reputed company
reputed company