Description
We are looking for a skilled and proactive Database Programmer with experience in database languages such as Oracle, SQL, and/or Postgres to join our team. This role will involve the development, maintenance, and optimization of database systems, with a focus on moving and managing databases in the cloud. The ideal candidate will have experience in database design, writing SQL queries, and some exposure to cloud migration processes.
Responsibilities
* Develop, maintain, and optimize databases in Oracle, SQL Server, and PostgreSQL environments.
* Write and maintain complex SQL queries, stored procedures, and functions to support application and reporting requirements.
* Perform database tuning and optimization to ensure optimal performance and scalability.
* Collaborate with cross-functional teams to integrate databases with various applications and services.
* Assist with database migration to cloud platforms (AWS, Azure, GCP) and manage cloud-based database solutions.
* Monitor database performance, troubleshooting issues, and providing support for production and development environments.
* Assist in the design and implementation of database schemas, data models, and data integrity strategies.
* Participate in database backup, recovery, and disaster recovery planning.
* Ensure database security best practices are followed and sensitive data is protected.
* Contribute to the automation of database deployment, backup, and monitoring processes.
* Document database structures, procedures, and workflows.
* Assist with testing and troubleshooting during cloud migrations and deployments.
Qualifications
* Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
* 4+ years of experience in database programming and management, including working with one of the following: Oracle, SQL Server, and PostgreSQL.
* Experience with database performance tuning and query optimization.
* Knowledge of database automation and deployment tools.
* Basic understanding of cloud-based database services (e.g., Amazon RDS, Azure SQL Database).
* Strong problem-solving and troubleshooting skills.
* Ability to work collaboratively with both technical and non-technical teams.
* Strong communication skills and attention to detail.
* Experience with NoSQL databases (e.g., MongoDB, Cassandra) is an advantage.
* Some experience with cloud migration projects is highly desirable.