Senior Database Developer - 150K Monthly

As a Senior Database Developer, you will:

Management and support of database solutions:

Perform optimization and tuning to support high transaction volume, complex query workloads and improve overall database performance.
Identify and resolve performance bottlenecks in SQL Queries and database operations.
Perform regular database maintenance tasks, including backups, restoration, and upgrades while ensuring minimal downtime.
Establish and maintain robust database security practices, including but not limited to role-based access controls, encryption, and vulnerability assessments.
Quickly address database-related incidents and provide long-term solutions to prevent recurrence.
Uphold best practices in code health, testing, and maintainability.
Provide 3rd level escalation for production support issues and customer concerns.
Process automation design and application builds:

Design, develop, and optimize PL/SQL programs to meet business requirements and project timelines.
Conduct thorough testing and debugging of PL/SQL procedures to ensure performance and reliability.
Design and implement data integration solutions to extract, transform, and load data from various sources into the database.
Perform data analysis, mapping and create migration plans for projects involving application and database migration
Develop ETL processes to ensure data quality, consistency, and accuracy.
Implement data integration solutions to synchronize data across different systems.
Work with stakeholders to understand data requirements and design scalable ETL workflows.
Collaborate with cross-functional teams to gather requirements, design logical and physical database structures, and ensure data integrity and security.
Analyze and predict future database capacity requirements and proactively plan for scalable solutions.
Implement monitoring, logging, and observability solutions to oversee system performance, troubleshoot issues and seek opportunities for improvement.
Document and maintain comprehensive database logs and records regarding system modifications and updates.
Document database designs, schemas, and processes to ensure knowledge transfer and maintain system documentation.
Follow prescribed SDLC & DevOps processes as well as comply with security best practices & policies.
Adhere to best practices in database development, version control, and change management.
Technical Skills improvement & Mentorship:

Recommend, design and develop training courses to improve team’s overall technical competency.
Continuously explore and integrate emerging database technologies and methodologies to enhance the data offerings.
Provide supervision and mentorship to junior staff.
Other:

Perform miscellaneous duties and projects as may be requested from time to time by the Software Development Lead.
What You Need:

Understanding of SDLC, Scrum, Agile Methodology
Strong proficiency in SQL (MS SQL and pgSQL) programming, including complex query writing and optimization.
Knowledge of data modeling techniques and database design principles.
Experience with ETL tools (SSIS, ADF, AWS Glue) and processes.
Expert understanding of SQL, query analysis, and performance tuning in PostgreSQL. Strong grasp of database principles, backup and recovery techniques, and replication
Proficiency in managing database security, replication, and scalability issues.
Proficiency Data Access and Databases (Microservices, REST APIs, PostgreSQL, AWS Glue)
Familiarity with cloud services (e.g., AWS) and the ability to work with diverse database technologies (e.g., Postgre, MS SQL).
Knowledge of modern database monitoring tools and techniques.
Experience in infrastructure as code is an advantage\
Familiarity with CI/CD tools (GitLab, Azure DevOps) and principles is a plus.
Knowledge of network architectures, cloud security, and compliance frameworks is a plus.

Strong Analytical skills:

Strong interpersonal, organizational, problem-solving and conflict resolution skills
Excellent communication skills, both written and verbal, capable of conveying complex information in a straightforward, understandable manner.
Ability to build relationships & work collaboratively with clients and organizational peers
Attention to detail and ability to work in a fast-paced, evolving environment while maintaining high standards of accuracy and confidentiality.
Qualifications (Non-negotiable):

Bachelor’s degree in Programming, Computer science and other relevant degree
5+ years of Database Development experience
3+ years of hands-on experience working with PostgreSQL and AWS Glue as their main database
Experience working directly with clients