What are the responsibilities and job description for the MAX - Senior Database Engineer (AWS Aurora/RDS PostgreSQLS) position at Lighthouse Technology Services?
Lighthouse Technology Services is partnering with our client to fill their Senior Database Engineer position with expertise in AWS Aurora / RDS PostgreSQL! This person will need expertise in Performance Tuning, Database Design and other DBA responsibilities as well. This is a 6 month contract-to-hire role and can be remote in the United States. This employee will be a W2 employee of Lighthouse Technology Services.
What You'll Be Doing :
- Create standards and recommend database features that can be leveraged for performance and scalability
- Proactively review databases and identify areas of improvement in current systems (optimization of views, stored procedures, indexes, fragmentation etc.)
- Work with application development teams to optimize slow performing queries
- Design, install, monitor, maintain, and performance tune production, test / development, and QA database environments while ensuring high levels of data availability.
- Define database development standards and work with application development teams to plan implementation
- Review functional and maintenance jobs and recommend and drive for improvements
- Review database settings and work with System DBA to make sure the settings are optimal
- Work with System DBA and Architect on defining and standardizing security best practices
- Monitor and Audit databases regularly to maintain quality
- Engage with development teams on database design and review database changes to make sure they align with architecture standards
- Recommend efficient tooling for development, monitoring, and troubleshooting
- Create roadmap for database patching and upgrades and utilize new technology / features available with upcoming database versions
- Provide technical leadership to drive and ensure adoption / consistency of best practices across multiple teams
- Collaborate with IT Security Architecture to ensure the Dev team follows standards and best practices
- Participate in Incident triages & on-call rotations.
- Strong Production DBA with strong PostgreSQL expertise providing operational support to business-critical systems.
- This person must have some experience working with Aurora PostgreSQL environment.
- 8-10 years experience building and maintaining complex mission-critical production database systems in PostgreSQL
- 3-5 years experience working with AWS Aurora / RDS PostgreSQL
- Strong knowledge of working with DMS, CloudWatch, Perfromance Insights and other DB monitoring tools like PMM or Foglight
- Deep knowledge of database internals, troubleshooting and performance optimization
- Experience migrating databases from other DB engines to Aurora / RDS PostgreSQL
- Excellent communication skills. Should be able communicate efficiently with customers and leaders, lead discussions during incident calls.
- Strong problem-solving skills and attention to detail
- Experience working with customers, resolving database, systems and infrastructure-related issues and also providing systems architecture leadership.
- Can analyzing issues holistically, from the application tier through the database, down to the storage.
- Broad awareness of customer workloads and use cases, including performance, availability and scalability
- Strong problem-solving skills and attention to detail
- Nice to have : AWS Cloud Practitioner certificate
- Well versed in Windows and Linux operating systems preferred
What You'll Need to Have :
Pay Range : $80-$89 / hr
Questions about any of our jobs? Email us at recruiting@lhtservices.com
View all of our open jobs here : jobs.lhtservices.com
Salary : $80 - $89
