Oracle/PostgreSQL Senior DBA

Company: NANA Regional Corp
Location: Alexandria
Posted on: September 9, 2023

Job Description:

**Work Where it Matters** Akima Global Technology (AGT), an Akima company, is not just another federal IT contractor. As an Alaska Native Corporation (ANC), our mission and purpose extend beyond our exciting federal projects as we support our shareholder communities in Alaska. At AGT, the work you do every day makes a difference in the lives of our 15,000 Iupiat shareholders, a group of Alaska natives from one of the most remote and harshest environments in the United States. **For our shareholders,** AGT provides support and employment opportunities and contributes to the survival of a culture that has thrived above the Arctic Circle for more than 10,000 years. **For our government customers,** AGT delivers new technologies and partners with leading edge commercial enterprises to deliver unique and innovative IT solutions. **As an AGT employee,** you will be surrounded by a challenging, yet supportive work environment that is committed to innovation and diversity, two of our most important values. You will also have access to our comprehensive benefits and competitive pay in addition to growth opportunities and excellent retirement options. **Job Summary:** For the Senior DBA role, were seeking a self-motivated, team leader, operating at as technical expert with strong abilities in Oracle, PostgreSQL and AWS migrations. The primary functions will include but not be limited to: Engagement Experience: Team Lead, Systems Design and Architecture (Maximum Availability Architecture, Golden Gate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using DataGuard, Backup and Recovery, Oracle LDAP) Systems installation and configuration (Oracle RDBMS, PostgreSQL, Oracle Application Server, Oracle LDAP, Oracle DataGuard), Database and Systems Administration (both production and develop operations and maintenance) Systems Analysis and Performance tuning (Oracle Database 19c, Oracle Weblogic, Oracle Application Server 10g, 9i, JVM Tuning etc., Application SQL and PL/SQL code tuning), Applications Development, Data Conversion, Data migrations, Performance and Functional Testing. Provide ORACLE engineering, design and administration services to several large-scale mission-critical ORACLE-based applications and environments. **Job Responsibilities:** + With broad and expert-level database technical knowledge and skills on Oracle databases, be able to provide database technical evaluation and recommendation on database design and architecture, integration and development, database high availability solution, database replication architecture, database backup, disaster and recovery strategies, grid computing and cloud management, database monitoring and management, performance tuning, database audit and security compliance and daily database operation and maintenance. + Hands-on experience with data migrations into AWS RDS, EC2, and Aurora. + Desirable to have experience migrating/rewriting views, stored procedures, functions from Oracle to PostgreSQL. + Senior level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views. + Senior level Postgres troubleshooting skills including identifying & resolving blocking, long running queries and other events that negatively impact the database. + With strong database administration skills, be able to monitor and manage proactively both mission-critical production and development database environments at the enterprise level. + Experience in Creating and cloning databases, Refreshing schemas using Export/import, Datapump. + Experience and knowledge of SQL queries and SQL Trace/Explain plans, SQL performance tuning. Setting Oracle parameters, and options. + Knowledge of creating and maintaining Tables, Partitioning, indexes, Triggers, stored procedures, etc. in a large terabyte database environment. + Hands-on experience on installation and configuration and troubleshooting of Oracle products and patches, including Exadata, RAC, ASM, Clusterware, Data Guard, OID, Grid/Cloud Control and DBaaS environments. + Evaluate Oracle features and Oracle related products Monitoring, troubleshooting & resolution of failed tasks & Oracle database issues, taking action on issues reported by proactive monitoring setup and having a sense of urgency to fix issues ASAP. + Solid experience in Linux, MS Windows, Linux Shell scripting Experience with Database links and Oracle heterogeneous services. + Writes database documentation, including data standards, procedures and definitions for the data dictionary. + An understanding of Oracle Definer rights is desired. + Provide direction to Jr DBA's. + Plan growth and changes (capacity planning) Sound knowledge of the SDLC, and experience in code migration, database change management and data management. + Solid project management/team lead skills, development teams, vendors, and systems administrators, and users. Professionalism, Patience, a good attitude and working as a team member is paramount. + Work as part of a team and provide 7x24 support when required Oracle Golden Gate experience is desired but not required. **Minimum Qualifications:** + 5 years database administration experience with recent experience in the following areas: * Oracle RAC. * Oracle Golden Gate. * Oracle Dataguard concepts. * AWS (Aurora, EC2, RDS). * PostgreSQL. + Experience with Red Hat Linux, Rocky OS. + US Citizenship and the ability to obtain and maintain a client specific Public Trust. **Desired Qualifications:** + Oracle technical certifications. + AWS Certifications. + Knowledge of USPTO mission and technical infrastructure. + MySQL experience. + Cassandra Experience. + Unisys DMSII experience. We are an equal opportunity employer. All applicants will receive consideration for employment, without regard to race, color, religion, creed, national origin, gender or gender-identity, age, marital status, sexual orientation, veteran status, disability, pregnancy or parental status, or any other basis prohibited by law. If you are an individual with a disability, and would like to request a reasonable accommodation for any part of the employment process, please contact us at job-assist@akima.com or 571-353-7053 (information about job applications status is not available at this contact information). **Job:** Information Technology **Travel:** No **Organization:** AGT **Clearance:** Able to Obtain Public Trust **Shift:** Day Job **Work Type:** Remote **Req ID:** AGT00182

Keywords: NANA Regional Corp, Alexandria , Oracle/PostgreSQL Senior DBA, IT / Software / Systems , Alexandria, Virginia