Database Engineer, Principal with Security Clearance - Washington, DC, United States - Technica Corporation

Description

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 , 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

• Active Top-Secret Clearance, with SCI eligibility.
• 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.