Database Administrator, Sr. (PostgresSQL) - Sierra7 (Texas)
Job Description
Sierra7, Inc. is seeking a Database Administrator to join a team providing full DEVOPS lifecycle support and services to the Department of Veterans Affairs (VA). This program will consolidate, reengineer, and sustain a suite of Veteran-facing processes. The candidate must be able to create, implement and manage expansive database administration programs. The Database Administrator must have experience reviewing database performance trends and identifying opportunities for improvement. The candidate must be able to build databases in accordance with business requirements.
Sierra7 is a US Small Business Administration (SBA) and Center for Veterans Enterprise (CVE)-verified Service-Disabled Veteran-Owned Business (SDVOSB) who provides Federal clients system and technology integration, program management, business process optimization, and enterprise solutions.
Position Responsibilities:
• Design, architect, and build databases translating from business requirements into DB designs
o Database design, database modeling, performance tuning, disaster recovery, replication, database documentation
o Work closely with programming staff on database design to meet business requirements
o Query performance tuning and database optimization
o Normalization and denormalization
• Ensure availability, security and integrity of assigned databases is at optimal performance
• Installation and configuration database management software (DBMS) and additional patches or service packs
• Establish and monitor user access, security and database roles, privileges, and permissions
• Utilization of security and recovery control tools and practices for successful database performance
• Analyze business needs and user stories to identify database administration technical solutions
• Participate in the requirements definition process to better understand the customer needs
• Ensure developed work products in adherence to established security and quality control standards for database development
• Collaborate with cross functional teams in Agile development
• Debug and correct database code, accessibility, and performance errors of assigned databases (PostgreSQL, Oracle, Liquibase, SQL, PL/sql, PL/pgSQL)
Required Skills and Experience:
• Demonstrated success as a Database Administrator
• Experience in a variety of database management software applications (PostgreSQL, Oracle, Liquibase, SQL, PL/sql, PL/pgSQL, AWS database offerings
o Experience performing a variety of database administration tasks in PostgreSQL (installation, maintenance, administration, migration, query tuning.
o Experience writing and troubleshooting complex stored procedures
• DevOps experience working within a Continuous Integration/Continuous Delivery program
• Scaled Agile Framework (SAFe) experience
• Experience maintaining database availability, security and integrity, performance of scheduled backups and database archiving methods
• Experience installing and configuring database management software (DBMS), database performance, capacity, replication
• Experienced in development of integrity checks, maintenance plans, updates of statistics monitoring of database security, database access, and hardware resource utilization
• Experience performing database scheduled and emergency backups and backup logs
• Experience in data transformation across systems and installation/test new versions of database management systems
• Demonstrated, strong analytical capabilities and technical knowledge by providing supportable technical solutions
• Strong oral and written communication skills
• Must be able to write database documentation, including data standards, procedures and definition for data dictionaries
Qualifications:
• Bachelor’s degree in computer science, electronics engineering, or other engineering or technical discipline is required. (8 years of additional relevant experience may be substituted for education)
• Minimum of 5 years of relevant experience
• SAFe development experience a plus
• Experience working in VA or other Government agency [desired]
• Agile / SAFe experience [desired]
• Ability to obtain a Government security clearance.
This is a full-time remote position.
Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.
Equal Opportunity Employer Veterans Disabled
Sierra7, Inc is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability. If you’d like to view a copy of the company’s affirmative action plan or policy statement, please email hr@sierra7.com. If you have a disability and you believe you need a reasonable accommodation in order to search for a job opening or to submit an online application, please e-mail hr@sierra7.com or call toll-free 1-833-452-2111. This email and phone number is created to assist disabled job seekers whose disability prevents them from being able to apply online. Only messages left for this purpose will be returned. Messages left for other purposes, such as following up on an application or technical issues not related to a disability, will not receive a response.
* This article was originally published here
