Database Developer/Admin

Introduction:

The candidate is an experienced IT Specialist and Oracle PL/SQL Developer with extensive expertise in database development, performance tuning, and data modeling. With a strong background in designing, implementing, and optimizing databases, he has successfully worked on complex systems, ensuring efficiency, scalability, and reliability. He is proficient in Oracle PL/SQL, SQL, PostgreSQL, and MySQL, with hands-on experience in ETL processes, Oracle Data Vault, and database partitioning. His expertise extends to CI/CD pipelines, database version control using Flyway and Liquibase, and automation with Shell scripting. He has a solid foundation in Java development, troubleshooting, and integrating database solutions with applications. Skilled in tools like Oracle SQL Developer, Jenkins, Toad, and Git, he has worked on performance analysis, query optimization, and system enhancements. With strong analytical and problem-solving abilities, he excels in identifying and resolving database-related issues, ensuring seamless operations and deployment. His experience also includes leading operational teams, collaborating with cross-functional teams, and maintaining technical documentation. He has a proactive, solutions-driven approach and is highly adaptable to new technologies and challenges in dynamic IT environments.

Responsibilities:

• Design, develop, and optimize Oracle PL/SQL and SQL database solutions for high-performance applications.
• Implement and maintain database structures, stored procedures, triggers, functions, and packages.
• Conduct performance tuning, query optimization, and troubleshooting to enhance system efficiency.
• Develop and automate ETL processes for data migration, transformation, and integration.
• Utilize Oracle Data Vault and database partitioning techniques for data security and efficient storage management.
• Implement CI/CD pipelines for database version control and deployment using Flyway and Liquibase.
• Automate database tasks and processes using Shell scripting and other scripting languages.
• Ensure data integrity, consistency, and security across multiple database environments.
• Collaborate with development teams to integrate databases with applications and backend systems.
• Conduct database administration tasks, including backup, recovery, and indexing strategies.
• Work with tools like Oracle SQL Developer, Toad, Jenkins, and Git for development and version control.
• Lead and mentor operational teams in database management, best practices, and troubleshooting.
• Create and maintain technical documentation, including database schemas, workflows, and procedures.
• Support agile development processes by providing database solutions aligned with business requirements.
• Analyze and resolve database-related issues, ensuring seamless system operations and uptime.
• Participate in system enhancements, migrations, and data warehouse implementations.
• Coordinate with stakeholders to define database requirements and implement scalable solutions.
• Conduct data analysis, reporting, and visualization to support decision-making and business insights.
• Implement and enforce database security policies, access controls, and compliance standards.