Senior Oracle Database Developer

Capitis Solutions Inc. was founded in 2007 and is a Maryland-based Information Technology consulting company, specializing in implementing modern applications. Our philosophy to align with the client’s organizational culture and provide cost effective, quality solutions is key to our success. Our approach to problem solving is unique and our clients benefit from the results in weeks rather than months.

We are seeking a skilled Senior Oracle Database Developer to join our team and contribute to the development and optimization of our database systems. The ideal candidate will have a strong foundation in Oracle database development, with a focus on complex SQL query development, PL/SQL programming, and performance tuning.

Key Responsibilities:Design, develop, and maintain complex SQL queries to extract and analyze data.Create and optimize PL/SQL stored procedures and functions to automate database tasks and improve performance.Conduct comprehensive performance tuning of complex SQL queries to ensure optimal database performance.Develop and maintain test data and test data scripts to support development and testing activities.Collaborate with development teams to understand and implement database requirements.Utilize JIRA and Bitbucket for project management and version control.Maintain detailed documentation of database design, processes, and procedures.Provide database support for development, testing, and production environments, including troubleshooting and resolving database issues.

Qualifications:Bachelor's degree in Computer Science, Information Systems, or a related field.Mastery and In-depth experience of 10+ years of Oracle Database Development experience with database design and normalization.Knowledge of Oracle performance tuning techniques, including the use of Oracle stats package and other equivalent tools.Familiarity with Oracle 19c version.Experience with Oracle AWS RDS.Familiarity with Snowflake and MS SQL Server is a plus.Excellent problem-solving and analytical skills.Ability to work independently and as part of a team.Experience with AWS cloud-based Oracle databases

Preferred Certifications:Oracle Certified Professional (OCP): Oracle Database Oracle Certified Associate (OCA): Oracle DatabaseOracle Certified Expert (OCE): Oracle Database Performance TuningAWS associate certifications

Key Skills

• AWS
• SQL