Database Developer

Job Summary:Techstra solutions is looking for a motivated Database Developer to join our team and play a key role in building, maintaining, and promoting our Enterprise Master Data platform. This individual will lead the technical design and development of database solutions, working closely with the Tech Manager while maintaining a self-starter mindset and an ownership mentality. The ideal candidate must be familiar with Agile Software Delivery Practices and capable of interfacing with multiple teams to drive data-driven solutions.Key Responsibilities:

• Lead the design and development of scalable, high-performance database solutions.
• Develop and maintain relational database services and components, ensuring efficiency and reliability.
• Implement and optimize database programming using SQL, PL/SQL, stored procedures, functions, triggers, and views in Oracle 12c or later.
• Work on full life-cycle development for data-centric applications.
• Optimize database performance, including query tuning, AWR reports, partitions, and indexing.
• Develop and manage Change Data Capture (CDC) solutions, with a strong preference for Oracle GoldenGate experience.
• Design and implement Dimensional Data Models for analytical and transactional systems.
• Ensure information security and access control for database systems.
• Develop and maintain ETL processes and integrate with related technologies such as Java and Python.
• Utilize Unix/Linux scripting (Bash, Python, etc.) for automation and data processing.
• Use version control and DevOps tools (Git, Jenkins, Liquibase) for database change management.
• Collaborate with cross-functional teams, providing technical guidance and best practices.
• Troubleshoot complex database-related issues and ensure high availability of services.

• Master’s or bachelor’s degree in computer science or related field.
• 8 years of experience in database architecture, design, development, and maintenance.
• Expertise in Oracle 12c or later with hands-on experience in SQL, PL/SQL, stored procedures, and performance tuning.
• Strong understanding of Dimensional Data Modeling and data-centric applications.
• Proficiency in complex SQL creation, optimization, and performance tuning.
• Experience with Change Data Capture (CDC), preferably Oracle GoldenGate.
• Knowledge of ETL processes, data integration, and programming languages like Java and Python.
• Proficiency in Unix/Linux scripting (Bash, Python).
• Experience using DevOps tools (Git, Jenkins, Liquibase) for database change management.
• Strong problem-solving, analytical, and critical-thinking skills.
• Excellent written and verbal communication skills for cross-team collaboration.

• Experience working with highly scalable enterprise databases.
• Exposure to big data technologies and advanced analytics.
• Certification in Oracle, AWS, or relevant database technologies.

Equal Employment Opportunity Statement

Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender,, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.

Powered by JazzHR

LD4Cp3qZeo