Oracle Database Administrator

ECS is seeking an Oracle Database Administrator to work in our Arlington, VA office.

Oracle apps DBA provides technical and functional support for database monitoring, database installation, database configuration, database administration, troubleshooting techniques, performance tuning and application system updates.

• Tune application SQL queries for performance optimization.
• Convert user stories into application logic, reports, printed outputs, and interfaces with other systems.
• Ability to turn high-level requirements into a working system through iterative development.
• Create acceptance criteria, develop automated test frameworks, and validate work products.
• Develop, validate, and maintain large, enterprise class, applications written in Oracle PL/SQL.
• Load data into tables.
• Profile server resource usage, optimize and tweak, as necessary.
• Help write and optimize in-application SQL statements.
• Help Reporting developers solve data load and data quality issues.
• Tune application SQL queries for performance optimization.
• Convert user stories into application logic, reports, printed outputs, and interfaces with other systems.
• Ability to turn high-level requirements into a working system through iterative development.
• Create acceptance criteria, develop automated test frameworks, and validate work products.
• Develop, validate, and maintain large, enterprise class, applications written in Oracle PL/SQL.
• Load data into tables.
• Profile server resource usage, optimize and tweak, as necessary.
• Help write and optimize in-application SQL statements.
• Help Reporting developers solve data load and data quality issues.
• Analyze and convert business requirements to technical requirements, followed by design and implement the solutions.
• Provide production deployment and production support as needed.
• Validate and fix data in the tables as appropriate.
• Validate the tables design / data quality for individual reports as based on business requirements.
• Collaborate with other team members and stakeholders.
• Participate in system administration and operational support (e.g., maintenance and support, reviewing and analyzing system logs and problem reports, adds, changes, backups, and file restores) and assist in monitoring of the system's performance and capacity planning
• Evaluates and implements new technologies, products and tools used in the application development environment
• Analyze performance issues in the application, concurrent manager and database tiers
• Manage resources to provide assistance to development teams with tuning database queries, reviewing and testing patches, configuration and code migrations. Develop purging, archiving, and cloning strategies
• Manage relationship with customers to understand customer and project needs and priorities

• Bachelor's degree in computer science, Computer Engineering, or a closely related field. Or equivalent work experience.
• US citizenship required per contract.
• Must be able to obtain and sustain a Secret Security clearance.
• Effective communication and interpersonal skills.
• Willingness to work with a team.
• Support Pentagon Operations in the Pentagon
• Work Surge hours and days, typically outside of normal duty hours, to include weekends and possible holidays
• Excellent Unit testing Skills.
• Ability to take requirements documentation from end users.
• Experience using Oracle Packages/Functions/Procedures.
• 6+ Years' Experience with Performance Tuning and optimizing SQL, PL/SQL code to reduce execution time or improve efficiency.
• 6 years' experience with the following skillsets: PL/SQL, SQL, PowerBuilder, UNIX shell scripting, GIT, BitBucket
• Experience analyzing complex business applications, developing logic flow charts, and translating detailed design into software.
• Hyperion development skills.
• Knowledge of the financial services industry desired but not required.
• Knowledge of working in Oracle relational databases.
• Strong SQL development, SQL analytics and tuning skills.
• Strong understanding of both structured and unstructured data.