TekSynap, a leading technology solutions company, is currently seeking a highly skilled and experienced Senior Database Developer for a position based in the vibrant city of New Orleans, Louisiana. In this role, the successful candidate will have the opportunity to work on exciting projects related to offshore energy and marine mineral resources, specifically under the BOEM and BSEE contracts. Key responsibilities will include providing support for Oracle and SQL databases, designing and developing comprehensive database schemas, optimizing database performance, implementing data security measures, and more. The ideal candidate will have a minimum of eight years of technical experience in software development, with a strong proficiency in SQL and PL/SQL, as well as knowledge of Oracle Database management. With the potential for telework and an office-based work environment, this position offers both flexibility and stability. However, it is important to note that a DOI Entrance on Duty (EOD) US citizenship is a requirement for this role. If you are a highly skilled Senior Database Developer seeking new challenges and opportunities, this position could be the perfect fit for you.
Read more about the Job you will love
Responsibilities
Supporting Oracle and SQL databases
As a Senior Database Developer at TekSynap, one of the main responsibilities is to support Oracle and SQL databases. This involves ensuring the smooth operation of the databases and providing any necessary technical support. This may include troubleshooting database issues, resolving performance problems, and collaboratively working with other teams to address any database-related concerns.
Designing and developing comprehensive database schemas
Another important responsibility of the Senior Database Developer is to design and develop comprehensive database schemas. This involves understanding the business requirements and translating them into efficient and effective database structures. By creating well-designed and properly structured database schemas, the Senior Database Developer plays a crucial role in ensuring the data is organized and easily accessible for various applications and systems.
Optimizing database performance
Optimizing database performance is a critical aspect of the role. The Senior Database Developer is responsible for continuously monitoring and analyzing the performance of the databases and identifying areas for improvement. This may involve tuning query performance, optimizing indexing strategies, and implementing caching mechanisms. By optimizing the database performance, the Senior Database Developer helps enhance the overall efficiency and effectiveness of the systems relying on the databases.
Implementing data security measures
Data security is of utmost importance in today’s digital landscape. As a Senior Database Developer, it is essential to implement robust data security measures to protect the confidentiality, integrity, and availability of the data. This may include implementing authentication mechanisms, controlling access rights, encrypting sensitive data, and regularly reviewing and updating security configurations. By implementing effective data security measures, the Senior Database Developer helps ensure the protection of sensitive information and maintains compliance with relevant regulations and standards.
Creating and maintaining database documentation
Clear and comprehensive documentation is essential for the successful management of databases. The Senior Database Developer is responsible for creating and maintaining database documentation that outlines the architecture, design, and configuration of the databases. This documentation serves as a valuable resource for other team members, enabling them to understand and work with the databases effectively. Regularly updating the documentation also helps ensure that it remains accurate and up-to-date, making it easier to onboard new team members and troubleshoot any issues that may arise.
Required Qualifications
Eight years of technical experience in software development
To be eligible for the role of Senior Database Developer at TekSynap, candidates must have a minimum of eight years of technical experience in software development. This experience should encompass various aspects of software development, including database design, programming, and troubleshooting. The extensive experience ensures that candidates have a strong foundational knowledge of software development practices and can effectively contribute to the development and maintenance of databases.
Proficiency in SQL and PL/SQL
Proficiency in SQL (Structured Query Language) and PL/SQL (Procedural Language/SQL) is a key requirement for the role. SQL is a programming language used for managing and manipulating relational databases, while PL/SQL is an extension of SQL that incorporates procedural and object-oriented programming capabilities. By possessing a high level of proficiency in SQL and PL/SQL, candidates can effectively interact with databases, retrieve and manipulate data, and write complex stored procedures and functions.
Knowledge of Oracle Database management
TekSynap’s database infrastructure primarily utilizes Oracle Database management systems. Therefore, candidates for the role of Senior Database Developer must have a strong knowledge of Oracle Database management. This includes understanding the architecture and components of Oracle Database, as well as being familiar with Oracle-specific features and functionalities. The knowledge of Oracle Database management ensures that candidates are well-equipped to work with the organization’s databases efficiently and effectively.
Familiarity with data modeling and database design principles
Data modeling and database design principles are essential for creating efficient and scalable databases. Candidates for the role of Senior Database Developer should have a strong familiarity with these principles. This includes understanding different data modeling techniques, such as entity-relationship modeling, and being able to translate business requirements into effective database designs. By possessing a solid understanding of data modeling and database design principles, candidates can create well-structured and optimized database schemas.
Experience with database performance tuning
Database performance tuning is a specialized skill that helps optimize the performance of databases. Candidates for the Senior Database Developer role should have hands-on experience with database performance tuning. This includes the ability to identify and resolve performance bottlenecks, fine-tune queries, and optimize indexing strategies. By having experience with database performance tuning, candidates can contribute to improving the overall performance and responsiveness of the databases.
Strong problem-solving skills
Strong problem-solving skills are crucial for a Senior Database Developer. This role involves troubleshooting complex database issues, identifying root causes, and implementing effective solutions. Candidates should possess strong analytical and critical thinking abilities, allowing them to approach problems systematically and develop innovative solutions. The ability to think critically and solve problems efficiently is essential for maintaining the reliability and availability of the databases.
Read more about the Job you will love
Preferred Qualifications
Experience with BOEM and BSEE contracts
TekSynap works on projects related to offshore energy and marine mineral resources and often collaborates with the Bureau of Ocean Energy Management (BOEM) and the Bureau of Safety and Environmental Enforcement (BSEE). Therefore, experience with BOEM and BSEE contracts would be a preferred qualification for the Senior Database Developer role. Familiarity with the specific contracting requirements and processes of these organizations would allow candidates to seamlessly integrate into the projects and contribute effectively.
Understanding of offshore energy and marine mineral resources
An understanding of offshore energy and marine mineral resources is another preferred qualification for the role. The Senior Database Developer may work on projects related to these industries, and having an understanding of the specific domain and industry requirements would be advantageous. This includes knowledge of the various stakeholders, regulatory frameworks, and technical considerations associated with offshore energy and marine mineral resources.
Knowledge of data warehousing and ETL processes
Data warehousing and Extract, Transform, Load (ETL) processes play a crucial role in managing and analyzing large volumes of data. Candidates with knowledge of data warehousing and ETL processes have an added advantage in the Senior Database Developer role. This includes understanding the principles of dimensional modeling, familiarity with ETL tools and techniques, and the ability to design and implement data warehousing solutions. The knowledge of data warehousing and ETL processes allows candidates to effectively manage and analyze large datasets.
Experience with database administration tasks
While the primary focus of the Senior Database Developer role is on database development, having experience with database administration tasks is also a preferred qualification. Database administration tasks may include tasks such as backup and recovery, monitoring and troubleshooting, and capacity planning. By having experience with database administration, candidates can have a holistic understanding of the database management lifecycle and contribute to the overall stability and reliability of the databases.
Ability to work in a fast-paced, deadline-driven environment
The Senior Database Developer role at TekSynap involves working in a fast-paced, deadline-driven environment. Candidates should possess the ability to effectively manage their time and prioritize tasks to meet project milestones and deliverables. The ability to work under pressure and meet deadlines ensures that candidates can successfully contribute to the organization’s projects and drive them to successful completion.
Work Environment
Mainly office-based
The work environment for the Senior Database Developer role at TekSynap is mainly office-based. This means that candidates can expect to primarily work within an office setting, collaborating with other team members and stakeholders. The office environment provides a structured and conducive workspace for focused work and communication.
Possibility of telework
In addition to the office-based work environment, there is also the possibility of telework for the Senior Database Developer role. This means that candidates may have the option to work remotely or from a different location, depending on the project requirements and organization’s policies. The possibility of telework allows for flexibility and the ability to work from a preferred location, providing a better work-life balance for candidates.
Citizenship Requirement
DOI Entrance on Duty (EOD) US citizenship
To be eligible for the Senior Database Developer role at TekSynap, candidates must possess DOI Entrance on Duty (EOD) US citizenship. This requirement is due to the nature of the projects and contracts that TekSynap works on, which may involve sensitive information and compliance with specific regulations. The US citizenship requirement ensures that candidates adhere to the necessary security and regulatory protocols.
Location
New Orleans, Louisiana
The Senior Database Developer role is based in New Orleans, Louisiana. Candidates should be willing to work in this location or relocate if necessary. New Orleans is known for its vibrant culture and rich history, making it an exciting place to live and work.
Company
TekSynap
The Senior Database Developer role is offered by TekSynap, an innovative technology company that provides advanced solutions to clients across various industries. TekSynap is a leader in delivering cutting-edge technology solutions, including database management, software development, cybersecurity, and IT consulting. As an employee of TekSynap, the Senior Database Developer will have the opportunity to work on challenging projects and contribute to the organization’s mission of delivering exceptional technology solutions.
