The Applications Support Oracle Developer/DBA supports the Lead in performing various tasks listed below:
- Assure and verify objects deploy correctly to the application-level databases across the DMDC environment. This includes triggers, indexes, data definition language, packages, stored procedures, views, and account profiles
- Provide table space sizing estimates for all database objects and partitioning recommendations in support of migrations to new technologies and infrastructures e.g. cloud, etc.? Additionally, collaborate with systems team to proactively monitor RDBMS space utilization
- Design, implement, monitor and tune Structured Query Language (SQL), Data Definition Language (DDL), and Data Manipulation Language (DML) statements stored in the database
- Coordinate with System DBAs to maintain, and support approved enterprise database objects
- Provide database support for all designated regions through a primary/secondary on - call personnel hierarchy
- Support review of the relational database management system (RDBMS) log files proactively for database problems to troubleshooting and remediation of issues
- Provide quality check on updates to databases and assure scripts updates to databases have the desired result. Provide necessary feedback to project teams
- Provide Database Restore and Recovery support in collaboration with the System DBAs
- Perform database conversions and migrations in support of application changes
- Support, maintain, and keep the test, development, and pre-production databases and database configurations consistent across environments
- Support data extracts from production databases in response to DMDC Data Requests. Ensure all DMDC privacy policies are enforced when extracting Personally Identifiable Information (PII)
- Assist those in the areas of Data Quality Control and Quality Assurance in verifying the accuracy and completeness of the data in DMDC databases
- Collaborate with the Tech Services teams to establish/control database security/annual password changes
- Report any unauthorized DDL activities to the appropriate government information assurance officers
- Make changes to database replication based on new requirements. Configure, maintain and monitor replication for errors and data consistency
- Verify replicated database synchronization utilizing the appropriate function and resolve any inconsistencies
- Support and maintain Oracle wallet repository in all regions
- Support and maintain monthly data archival
- Create/maintain UNIX shell scripting for DBA tasks
- Update data sources/batch files on servers/maintain credentials for databases
- Able to provide 24/7 support 365 days of the year
- Good understanding?of Oracle internals and objects
- Minimum 3+ years' experience working with Oracle databases within Linux and Unix environments
- Expert level of SQL and PL/SQL skills: Query optimization, troubleshooting and performance tuning
- Experience in design, development, testing, implementation, and support of database objects including but not limited to data models, triggers, packages, procedures, functions, and data loads.
- Experience of UNIX and Linux Servers, ability to read, develop and test UNIX shell scripts
- Experience in data migration project: thoroughly testing the migration of data from one data structure to another
- Experienced in Oracle data pump, export/import process, table space point-in-time recovery
- Good analytical, written and communication skills
- Performance tuning of indexes, tables, optimization of storage functionality, and databases in general
- Knowledge in creating automated testing scripts
- Respond to system failures and work with developers, customers, and vendors to resolve issues related to database servers and related hardware
- Regular and proactive performance monitoring of various database structures, activities and users, noting performance and other problems, diagnosing the cause and implementing a remedy
- Self-motivated and work well in a team environment
- Adapt to new technologies and priorities
- Oracle Database Security
- Understanding of Pro*C is desired
Non-Negotiable Requirements:
REQUIRED EDUCATION AND EXPERIENCE:
- Minimum 5+ years' experience working with Oracle databases within Linux and Unix environments
- Bachelor’s degree (preferred but not required)
- Must be located on East Coast
REQUIRED CLEARANCE:
- Secret clearance
REQUIRED CERTIFICATIONS:
- Security+ CE
Technical Environment:
On-prem ServiceNow instance hosted by a third party, not ServiceNow cloud. Windows 10 or Windows 11 operating systems; Microsoft 365 Office suite of applications Oracle, UNIX/Linux, test scripts
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
Salary Description114,400