Database Engineer, Principal

Overview: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 an experienced Database Engineer, Principal PostgreSQL Subject Matter Expert (SME) to lead our database team. The ideal candidate will have a robust background in database administration, architecture, and PostgreSQL development. The SME will be responsible for ensuring the performance, integrity, and security of the unit’s PostgreSQL databases.
Responsibilities:

• Design and implement database architectures that support business requirements and achieve high performance, availability, and security.
• Oversee the installation, configuration, and maintenance of PostgreSQL databases.
• Conduct performance tuning of database systems, including queries, stored procedures, and indexing strategies.
• Develop and implement database backup, recovery, and failover procedures.
• Assist in the design and development of data models and database solutions.
• Collaborate with development teams to optimize database code in application layers.
• Provide guidance on database best practices to IT staff and other stakeholders.
• Ensure database infrastructure is up-to-date with the latest technology trends and security patches.
• Develop and maintain documentation regarding database configurations, architectures, and procedures.
• Serve as the point of contact for database-related queries and technical support.

This is position is required to be onsite in our Patriot’s Plaza II location in Washington, D.C. 8 hour shift within the window of 0700 – 1700, Monday – Friday
The government has established policies for on-site vs remote work which varies across divisions and contracts. Staff are obligated to adhere to these and other FBI policies and react accordingly as policies change over time. Where allowed, remote work must be coordinated with the team lead and/or government POC, ensuring there is zero interruption with the delivery of our services.
Requirements:

• Must have Active Top-Secret Clearance, with SCI eligibility to apply.
• Bachelor’s degree and 10 years experience or Master’s degree in Computer Science, Information Technology, and 8 years experience in related field.

• Strong expertise in PostgreSQL database administration, tuning, management, and security.
• Proficiency in SQL and experience with PL/pgSQL or similar procedural language.
• Familiarity with database design, documentation, and coding.
• Previous experience with Linux/Unix and scripting languages such as Bash, Python, or Perl.
• Knowledge of high availability and disaster recovery options for PostgreSQL.
• Good understanding of hardware performance, memory and I/O.
• Strong analytical and problem-solving skills.
• Excellent communication and mentoring skills.Desired:

• PostgreSQL certification (e.g., PostgreSQL Certified Engineer).
• Experience with cloud services (AWS, Azure, OCI) and containerization technologies (Docker, Kubernetes).
• Familiarity with other database systems (e.g. Oracle and MSSQL)

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.

Job Type: Full-time

Pay: $129,414.76 - $155,854.33 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Tuition reimbursement
• Vision insurance

Experience level:

• 11+ years

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Work Location: In person