Principal Database Developer

TekSynap•New Orleans, LA

12d•$115,000 - $123,000

About The Position

TekSynap is seeking a Principal Database Developer to support the DOI BSEE TIMS contract in New Orleans, Louisiana. The role supports database and application development for work associated with the Bureau of Ocean Energy Management and the Bureau of Safety and Environmental Enforcement. The developer will design, build, secure, document, maintain, and optimize Oracle and SQL databases and related applications. The position includes database modeling and schema development; query writing and tuning; ETL development; capacity planning; database migrations; troubleshooting; and collaboration with users, administrators, developers, and other teams. The role may also involve directing others and mentoring junior database developers. This is a day-shift position, Monday through Friday, in an office environment; telework may be available. Evening and weekend work may be requested to meet program and contract needs. Travel is less than 10%. The position requires a DOI Entrance on Duty (EOD), and applicants must be able to pass a DOI background investigation and obtain a Public Trust Clearance. The target salary range is $115,000 to $123,000.

Requirements

Ten years of technical experience in applications software development, including three years in systems analysis and one year acting as a technical lead.
Master’s degree in Engineering, Computer Science, or an area related to the project’s functional requirements.
Good understanding of the business or function for which the application is designed.
Proficiency in software languages such as HTML, Java, JavaScript, Postgres, Python, CSS, SQL, NoSQL, C#, Perl, or other languages as required.
Competence working at a high level across all phases of system and database development and management.
Ability to pass a DOI background investigation and obtain a Public Trust Clearance.

Nice To Haves

Strong SQL skills for querying and manipulating data in Oracle databases.
Proficiency in PL/SQL for developing stored procedures, triggers, and functions.
Proficiency in Oracle Database management, including database architecture, SQL, PL/SQL, and database design principles.
Strong problem-solving skills for troubleshooting and resolving database issues.
Ability to design and implement database structures, including tables, indexes, and constraints, for data integrity and performance.
Understanding of performance-tuning techniques and the ability to optimize database performance.
Familiarity with Oracle Enterprise Manager, Oracle Data Pump, and Oracle Recovery Manager.
Knowledge of Unix/Linux and Windows operating systems.

Responsibilities

Use efficient methodologies to support Oracle and SQL databases.
Design and develop database schemas and objects, including tables, views, indexes, triggers, stored procedures, and functions.
Create optimized SQL queries and reports and integrate data across systems and applications.
Work with end users and administrators to understand data needs, improve performance, and maintain data quality.
Monitor and optimize database performance through query tuning, index optimization, and resource management.
Implement and enforce data security measures, including access controls, encryption, and authentication.
Create and maintain data models that represent organizational data structures and relationships.
Document database architecture, configurations, and processes.
Develop and maintain ETL processes to move, transform, and load data while ensuring consistency and quality.
Plan for data growth and resource needs and scale database infrastructure accordingly.
Plan and execute database migrations while minimizing business disruption.
Diagnose and resolve database issues in coordination with developers, system administrators, and other teams.
Guide and mentor junior database developers and team members.
Formulate and define system scope and objectives.
Devise or modify procedures to solve complex problems while considering computer equipment capacity and limitations.
Prepare detailed specifications for programs.
Design, code, test, debug, and document programs.
Participate in the design, implementation, integration, management, and maintenance of complex databases, including operating-system considerations, access methods and times, device allocation, validation, organization, security, documentation, guidelines, and statistical methods.
Evaluate commercial off-the-shelf products and analyze hardware and software issues.
May direct the work of others.