Job description

Description: Columbia Technology Partners is seeking an Oracle Data Steward / Oracle Database Developer to support enterprise data management and database modernization initiatives. This role combines hands-on Oracle database development with data stewardship responsibilities, ensuring the quality, integrity, security, and usability of critical business data. The ideal candidate will collaborate with stakeholders across the organization to develop database solutions, improve data governance practices, support data migration efforts, and optimize database performance in support of mission and business objectives. Key Responsibilities: • Maintain the quality, integrity, consistency, and security of enterprise data assets while supporting data governance policies, standards, and best practices. • Analyze, troubleshoot, and resolve data quality issues through profiling, validation, cleansing, reconciliation, and ongoing monitoring efforts. • Develop, test, and maintain Oracle database applications, including complex PL/SQL packages, procedures, functions, triggers, views, and materialized views. • Create, optimize, and support SQL queries for reporting, analytics, application support, and system integrations. • Plan and execute data migration initiatives, including data extraction, transformation, validation, loading, and reconciliation activities. • Develop scripts and automation tools to support data conversion, migration, and integration processes. • Analyze and tune SQL and PL/SQL performance, optimize database objects, and support application reliability and scalability. • Maintain database security through role management, auditing, access controls, and compliance-focused practices. • Collaborate with business stakeholders, developers, administrators, and project teams to define data requirements and migration strategies. • Prepare and maintain technical documentation, data dictionaries, migration plans, operational procedures, and data quality reports. Qualifications: • Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field (or equivalent experience) with 5+ years of Oracle database development experience. • Strong expertise in Oracle SQL, PL/SQL, Oracle Database 19c, and the development of packages, procedures, functions, triggers, views, and materialized views. • Experience planning and executing data migration initiatives, including ETL/ELT processes, data mapping, validation, conversion, and reconciliation. • Proven experience with SQL performance tuning, data governance principles, data quality management practices, and tools such as Jira, Confluence, and Git. Desired Skills: • Experience supporting large-scale enterprise data environments and complex database ecosystems. • Knowledge of metadata management, data lineage, master data management, and enterprise data governance frameworks. • Experience with cloud migration, database modernization, or large-scale system integration initiatives. • Strong communication, documentation, problem-solving, and stakeholder engagement skills with the ability to bridge technical and business teams. Requirements: • U.S. Citizenship is required for all applicants. CTP is an equal opportunity employer and abides by applicable employment laws and regulations. All applicants and employees are subject to random drug testing in accordance with Executive Order 12564. Employment is contingent upon successful completion of a security background investigation and polygraph. • Certification Requirements: • N/A This position requires an active Security Clearance with appropriate Polygraph. About us: Founded in 2007, Columbia Technology Partners is a Service-Disabled Veteran Owned Small Business with a specialization in technology and management consulting committed to solving intricate and sensitive technology issues facing corporations and federal agencies. Since its inception, CTP has been instrumental in the technical design, engineering development, operational deployment, and support of key systems. With a proven track record in information security, project management, systems/network engineering, security risk management, vulnerability assessments, and mobile security implementation; our employees have the experience, expertise, and innovative thinking our customers need for results that exceed expectations. CTP staff have worked closely with both government engineers and management to gather mission requirements, develop the architecture to deliver the needed functionality and assess tools available to meet or exceed the needs of the mission. At Columbia Technology Partners (CTP), we are united in being the best that we can be as individuals, but our core belief is that we can be better together. Together we will take on each mission with an execution process that authentically represents who we are. Our success relies on our team values, the foundation we built around them, and the Partners we become along the way. That's why our pay is competitive, our missions are critical, and our benefits represent what matters most to CTP: Our People. Salary Range Transparency At Columbia Technology Partners we are committed to transparency and fairness in our compensation practices. We believe in creating a work environment where employees feel valued, empowered, and rewarded for their contributions. How We Determine Salary Ranges Our salary ranges are based on the following key factors: • Job Role and Responsibilities : The specific duties and responsibilities associated with each role form the foundation of our compensation structure. • Market Research and Industry Benchmarks : We conduct regular analysis of market trends and salaries across our industry, using reliable compensation data to ensure we stay competitive. • Experience and Qualifications : An individual's experience, education, certifications, and specialized skills all contribute to determining their position within a salary range. • Location : Salary ranges may be adjusted based on geographic cost of living, in accordance with local and national standards. • Company Performance : Our compensation practices also take into account overall company performance and financial health, ensuring that we maintain sustainability while rewarding our team. Really good benefits, for really GREAT people: From our CTP Family to yours, we know how important these decisions are. Your benefits are about you, not us. Tell us what you need in order to see a future at CTP; let's get where you're going, together . Medical: CTP offers 3 superior plans, bringing our employees both in-network and out-of-network options. Vision + Dental: Both free to you + paid in full by CTP. Retirement: 401k - 6% company contribution PTO + Leave: A work life balance is extremely important to our team here at CTP, which is why our paid time off plans are so lucrative. Offering customizable leave plans to meet your needs is just one of our many perks! Jury Duty, Bereavement + Military Leave provided. Career Growth: Up to $10,000 provided for approved career-related learning, training, education, and/or tuition. Life and AD&D Insurance/Short-Term & Long-Term Disability: More peace of mind, at zero cost to you. Profit Sharing Bonus: End of year cash gets added to your bottom-line. Referral Bonus Program: Our tiered program provides an incentive with each stage of the hiring process your referral passes. Our bonuses range from $7,000-$20,000, if your referral joins the team. Columbia Technology Partners is an Equal Opportunity Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state, or local law. Our EEO policy reflects our commitment to ensure equality and promote diversity and inclusion in the workplace. Our policy applies to all employees, job candidates, contractors, stakeholders, partners, and visitors. CTP was voted one of the top 25 best places to work in Baltimore by Baltimore Magazine!

Requirements

Must-haves

Maintain the quality, integrity, consistency, and security of enterprise data assets while supporting data governance policies, standards, and best practices.
Analyze, troubleshoot, and resolve data quality issues through profiling, validation, cleansing, reconciliation, and ongoing monitoring efforts.
Develop, test, and maintain Oracle database applications, including complex PL/SQL packages, procedures, functions, triggers, views, and materialized views.
Create, optimize, and support SQL queries for reporting, analytics, application support, and system integrations.
Plan and execute data migration initiatives, including data extraction, transformation, validation, loading, and reconciliation activities.
Develop scripts and automation tools to support data conversion, migration, and integration processes.
Analyze and tune SQL and PL/SQL performance, optimize database objects, and support application reliability and scalability.
Maintain database security through role management, auditing, access controls, and compliance-focused practices.
Collaborate with business stakeholders, developers, administrators, and project teams to define data requirements and migration strategies.
Prepare and maintain technical documentation, data dictionaries, migration plans, operational procedures, and data quality reports.
Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field (or equivalent experience) with 5+ years of Oracle database development experience.
Strong expertise in Oracle SQL, PL/SQL, Oracle Database 19c, and the development of packages, procedures, functions, triggers, views, and materialized views.
Experience planning and executing data migration initiatives, including ETL/ELT processes, data mapping, validation, conversion, and reconciliation.
Proven experience with SQL performance tuning, data governance principles, data quality management practices, and tools such as Jira, Confluence, and Git.
This position requires an active Security Clearance with appropriate Polygraph.
From our CTP Family to yours, we know how important these decisions are. Your benefits are about you, not us. Tell us what you need in order to see a future at CTP; let's get where you're going, together .
Medical: CTP offers 3 superior plans, bringing our employees both in-network and out-of-network options.
Vision + Dental: Both free to you + paid in full by CTP.

Nice-to-haves

Experience supporting large-scale enterprise data environments and complex database ecosystems.
Knowledge of metadata management, data lineage, master data management, and enterprise data governance frameworks.
Experience with cloud migration, database modernization, or large-scale system integration initiatives.
Strong communication, documentation, problem-solving, and stakeholder engagement skills with the ability to bridge technical and business teams.
Profit Sharing Bonus: End of year cash gets added to your bottom-line.
Referral Bonus Program: Our tiered program provides an incentive with each stage of the hiring process your referral passes. Our bonuses range from $7,000-$20,000, if your referral joins the team.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqljira

Platform: isolved
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Pto

Paid Time Off