Database Programmer

Chitra Productions; Northern (KY); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Chitra Productions is seeking a Database Programmer to design, develop, and optimize database solutions that support business applications, reporting systems, and enterprise data management.

The role involves creating database objects, developing data integration processes, ensuring data integrity, and improving performance across operational and analytical environments.

Qualifications

• Bachelor’s degree in CS/IT/SE or related field.
• 3–8+ years of experience in database development and programming.
• Strong proficiency in SQL and relational database concepts.
• Experience with Oracle, SQL Server, IBM Db2, PostgreSQL, and MongoDB.
• Experience developing stored procedures, triggers, functions, and database packages.
• Knowledge of data modeling and normalization techniques.
• Strong analytical and problem-solving skills.

Responsibilities

• Design, develop, and maintain database structures, stored procedures, functions, triggers, and views.
• Write and optimize SQL queries for application support and reporting requirements.
• Develop ETL processes for data migration and integration.
• Monitor database performance and implement tuning strategies.
• Troubleshoot database issues, data anomalies, and application performance problems.
• Support database security, backup, recovery, and disaster recovery procedures.
• Collaborate with software developers, system administrators, and business stakeholders to implement database solutions.
• Maintain data quality, consistency, and integrity across multiple systems.
• Create and maintain technical documentation, data dictionaries, and database standards.

Skills

Strong analytical skills

Experience in database development

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle Database

Microsoft SQL Server

IBM Db2

PostgreSQL

MongoDB

Job description

Position Summary
The Database Programmer designs, develops, maintains, and optimizes database solutions that
support business applications, reporting systems, and enterprise data management. This role is
responsible for creating database objects, developing data integration processes, ensuring data
integrity, and improving database performance across operational and analytical environments.

Key Responsibilities

• Design, develop, and maintain database structures, stored procedures, functions, triggers,
  and views.
• Write and optimize SQL queries for application support and reporting requirements.
• Develop ETL (Extract, Transform, Load) processes for data migration and integration.
• Monitor database performance and implement tuning strategies to improve efficiency.
• Troubleshoot database issues, data anomalies, and application performance problems.
• Support database security, backup, recovery, and disaster recovery procedures.
• Collaborate with software developers, system administrators, and business stakeholders
  to implement database solutions.
• Maintain data quality, consistency, and integrity across multiple systems.
• Create and maintain technical documentation, data dictionaries, and database standards.

Support system upgrades, migrations, and modernization initiatives

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering,
• or related field.
• 3–8+ years of experience in database development and programming.
• Strong proficiency in SQL and relational database concepts.
• Experience with one or more database platforms:
• Oracle Corporation Oracle Database
• Microsoft SQL Server
• IBM Db2
• PostgreSQL Global Development Group PostgreSQL
• MongoDB MongoDB
• Experience developing stored procedures, triggers, functions, and database packages.
• Knowledge of data modeling and normalization techniques.
• Strong analytical and problem-solving skills.

Preferred Qualifications

• Experience with cloud database technologies such as:
• Amazon Web Services AWS RDS/Aurora
• Microsoft Azure SQL
• Google Google Cloud SQL
• Familiarity with data warehousing concepts and business intelligence tools.
• Experience with scripting languages such as Python, PowerShell, or Bash.
• Knowledge of database security and compliance frameworks.
• Relevant certifications such as:
• Oracle Database Certification
• Microsoft Azure Database Administrator Associate
• AWS Database Specialty

Desired Technical Skills

• SQL, PL/SQL, T-SQL, or PostgreSQL programming
• Database performance tuning and optimization
• ETL development and data integration
• Data modeling and schema design
• Database replication and high availability
• Backup and recovery management
• Data warehousing and reporting
• Version control systems (Git)