Database Engineer, Principal with Security Clearance
Technica Corporation
2024-11-08 05:43:58
salary: 165000.00 US Dollar . USD Annual
Washington, District of Columbia, United States
Job type: fulltime
Job industry: I.T. & Communications
Job description
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 Cyber Security, and from Software Development to Product Solutions. From our locations across the DC Metro area, Hampton, Virginia, 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. The annual base salary range for this position is $155,000 - $165,000. Please note that the salary information is a general guideline only. Technica considers factors such as scope and responsibilities of the position, candidate's work experience, education/training, key skills, location, as well as market and business considerations when extending an offer. 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.