Database Developer III

: Overview: About Technica : At Technica Corporation, our goal is to provide exceptional professional services and innovative technology solutions that meet or exceed our customer's expectations. We specialize in a wide range of advanced information technology solutions from Systems Engineering to Information Assurance, and from Software Development to Product Solutions. From our locations across the DC Metro area, San Antonio, Texas and Huntsville, Alabama, we provide technological subject matter expertise, program management and business process knowledge as a trusted advisor in support of our Department of Defense and other Federal Agency customers. Responsibilities: Technica is seeking a Database Developer III to support our team in Redstone Arsenal in Huntsville, AL. The successful candidate will be responsible for SQL and PL/SQL development to include:

• Developing the backend reports to support user needs.
• Developing custom scripts to automate various database management processes, monitoring and troubleshooting database performance.
• Developing, optimizing, and tuning stored procedures, functions, triggers, views, and queries in support of application development.
• Interfacing with customers, users, and developers as needed.
• Maintaining the database schema, database design, and transition development activities.
• Providing technical subject matter expertise (SME) on ingesting into the database from sources such as file systems, and perform maintenance, to include tuning with various transition implementation strategies with in-house developed applications.
• Resolving various database issues, to include problems with data modeling, design, queries, security control, backup/restore, disaster recovery, and import/export data, as well as coordinate with data ingest efforts with regard to database operations.
• Auditing performance by performing advanced activities such as load testing, response time testing.
• Providing a report on these activities on an on-going basis so that overall system performance may be documented and charters in the service level agreements (SLAs) are met.

Requirements:

• Active Top-Secret clearance with SCI eligibility.
• Bachelor's degree in Engineering, Computer Science, or other related analytical, scientific, or technical discipline.
• Minimum 5 years of experience in software development/engineering, including requirements analysis, software development, installation, integration, evaluation, enhancement, maintenance, testing, and problem diagnosis/resolution.
• 5 to 7 years creating complex queries, stored procedures, functions, and reports using SQL.
• Ability to download data using Linux Bash command line scripts.
• Manipulate data in Oracle tables to create custom reports using Oracle Label Security.
Good understanding of legal requirements for taints, purges, and how markings work
• -quick learner of complex business rules.

Desired:

• Experience with Agile and Scrum methodologies.
• Experience with Oracle 19c.
• Experience developing scripts in Windows PowerShell and/or Linux Bash scripts.

EEO:

EQUAL EMPLOYMENT OPPORTUNITY

It is Technica's policy to affirmatively support Equal Employment Opportunity (EEO) for all qualified individuals without regard to color, gender, religion, creed, national origin, age, race, disability, gender identity, genetic information, sexual orientation, marital status, veteran status or any other characteristic protected by law. This policy covers all aspects of the employment relationship including recruiting, hiring, compensation, assignment, promotion, transfer, training, working conditions, employment longevity, retirement, employee benefits and termination.

Technica's EEO philosophy promotes equal employment opportunity throughout the organization. Any form of unlawful employee harassment based on the above mentioned characteristics is prohibited. Equal Opportunity Employer Minorities/Women/Vets/Disabled/Gender Identity/Sexual Orientation.