2 years ago
New Orleans, LA, USAStaff+
Base Salary
$115k - $123k/yr
Responsibilities
- Design and develop database schemas containing tables, views, indexes, triggers, stored procedures, functions, and other database objects.
- Write optimized SQL queries, generate reports, and integrate data across systems and applications.
- Monitor and optimize database performance through query tuning, index optimization, and resource management.
- Implement database access controls, encryption, authentication, and other data security measures.
- Create data models, document database architecture and processes, and maintain data quality.
- Develop and maintain ETL processes for moving and transforming data from multiple sources.
- Perform capacity planning, database scaling, migrations, troubleshooting, and issue resolution.
- Design, code, test, debug, and document programs and participate in database design, implementation, integration, management, and maintenance.
- Provide guidance and mentorship to junior database developers and may direct the work of others.
Requirements
- At least 10 years of technical experience in applications software development, including three years in systems analysis and one year serving 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 with software languages and technologies such as HTML, Java, JavaScript, Postgres, Python, CSS, SQL, NoSQL, C#, Perl, or other required languages.
- Competence across all phases of system and database development and management.
- Strong SQL skills for querying and manipulating Oracle databases and proficiency in PL/SQL.
- Proficiency in Oracle Database management, architecture, SQL, PL/SQL, and database design principles.
- Ability to design database structures and optimize performance while ensuring data integrity.
- Familiarity with Oracle Enterprise Manager, Oracle Data Pump, and Oracle Recovery Manager.
- Knowledge of Unix/Linux and Windows operating systems.
- Ability to pass a DOI Background Investigation and obtain a Public Trust Clearance.
Benefits
- Health, dental, and vision insurance.
- 401(k), life insurance, and short- and long-term disability plans.
- Vacation time and holidays.
- New Orleans, Louisiana office-based role with telework potentially available.
- Day shift Monday through Friday; evenings and weekends may occasionally be required for program and contract needs.
- Less than 10% travel.
- Requires a DOI Entrance on Duty and may involve drug screening and government investigation requirements.
Tech Stack
Categories
BackendData Engineering
About TekSynap
TekSynap provides IT services and systems integration for government customers, including infrastructure operations, application development, wireless engineering, help desk, and DevOps across cloud and on‑premise environments. The privately held firm serves U.S. federal, state, and local agencies—work has included programs for the Department of Veterans Affairs and defense communities—through long-term contracts and managed services. Founded in 2008 and headquartered in Virginia, it supports mission environments with Agile, security‑cleared teams.