Database Architect and Administrator

Job Description

Job Description

Description:

Position Summary

Precise is seeking an Oracle database specialist to support a large FDA program in the Baltimore and/or Rockville area. The program is a large development effort, primarily using technologies such as java/cold fusion/oracle forms. The ideal candidate will work with the development team performing various tasks such as data modelling, writing DDL scripts for database updates, creating/updating stored procedures and other custom scripts, documenting deployment procedures for FDA DBAs to complete deployments in higher environments and supporting FDA users with data issues.

Successful candidates must be able to complete a Public Trust background check .

Key Responsibilities

The Oracle Database Architect responsibilities will include:

• Working with Business Analysts on database design changes needed per requirements
• Creating logical and physical data models from user requirements
• Providing database support for development and deployment of database scripts in Development and Test environments. Works in conjunction with other teams in the database administration of the Pre-Production and Production environments
• Creating scripts for tables and other objects like triggers and procedures is our day-to-day
• Performing data migrations
• Maintaining data standards, including adherence to the Data Protection Act
• Communicating regularly with technical, applications, and operational staff to ensure database integrity and security
• Assisting customers with issues related to applications involving issues with PL/SQL code, UNIX shell scripts, cron job code running in development and production environments
• Developing Oracle stored procedures, packages, functions, and triggers in support of new applications being deployed
• Recommending solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
• Implementing new releases and completing maintenance requirements
• Monitoring performance and managing parameters to provide fast query responses to front-end users

The role may also include, as needed:

• Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly
• Support for writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Ability to support the updating of Security Artifacts and environment Vulnerability Analysis
• Controlling access permissions and privileges

• Bachelor’s degree from an accredited college in a related discipline, or equivalent experience/combined education, with 6-7 years of professional experience; or 5 years of professional experience with a related Master’s degree. Considered an emerging authority.
• Oracle DBA and Architect experience required
• Experience with PL/SQL, SQL Queries, procedures, triggers, and DDL
• Hands-on experience in DB application development
• Knowledge of RDBMS design
• Experience with Oracle Data Pump

Preferred Qualifications

• Data Modeling
• Highly proficient in core DBA skills spanning multiple releases like Oracle 10g, 11g and 12c
• Data warehouse and/ or ETL Experience with WebLogic installation
• Experience with Performance tuning (DB, SQL, PL/SQL)
• Experience in writing and modifying UNIX Shell Scripts
• Certified Oracle Administrator
• Oracle Forms
• Experience with Oracle 11g Exadata and Exalogic architecture, Oracle 10g/11g/ 12c

ABOUT US

Precise Software Solutions, Inc. is a mission-focused technology services company delivering secure digital platforms, infrastructure, and operational IT services to government organizations. A CMMI Level 3–appraised company, Precise partners with agency technology leaders and solution providers to design, build, operate, and modernize enterprise IT solutions that support critical public missions combining agility, innovation, and performance to deliver measurable results.

Precise specializes in cloud and hybrid infrastructure, platform engineering, security operations and compliance, application modernization, and data platforms and analytics. The company is known for its agile, delivery-driven approach and innovative engineering practices, applying operational rigor and performance-focused execution to improve system resilience, security, and scalability across complex government environments.

BENEFITS AND PERKS

• Comprehensive Health Benefits (Medical, Dental and Vision)
• Flexible Spending Accounts (FSA) & Health Savings Account (HSA)
• Retirement Plan with 4% match and discretionary match at year end
• Paid Time Off (PTO): 15 days of PTO accrued per year; 7 holidays+ 3 Floating holidays; 2 Innovation days (paid training days)
• Short Term and Long-Term Disability
• Paid Parental Leave
• Paid Jury Duty leave
• Life and AD&D Insurance
• Critical Illness Insurance
• Training and Development
• Wellness Incentives & Discount programs
• Employee Referral Program
• Annual Charity Donation Match
• Awards and Recognition

Equal Employment Opportunity Statement

Precise Software Solutions is committed to providing a workplace free from discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, age, national origin, disability, sexual orientation, gender identity or expression, marital status, genetic information, protected veteran status, or other legally protected status.

We are an inclusive organization and actively promote equality of opportunity for all with the right mix of talent, skills and potential. We expect every member of the Precise community to do their part to cultivate and maintain an environment where everyone has the opportunity to feel included and is afforded the respect and dignity they deserve.