Data/Database Administration

Hello All,
Hope you are doing well

position: Database Administration
Location: Trenton, NJ (Remote)
Duration: Long Term

Job Description:

• The DEV/DBA shall be responsible for, but not limited to, the following tasks and activities:
• Design and implement both front-end and back-end functionalities, ensuring seamless communication through the development and integration of RESTful APIs. Implement robust data validation rules and integrity constraints to ensure data accuracy and reliability.
• Partner with project managers, designers, QA/BQA teams, and other stakeholders to translate business requirements into comprehensive technical specifications and effective solutions.
• Proactively identify, diagnose, and resolve performance bottlenecks, bugs, and production issues across both front-end and back-end systems, ensuring a smooth user experience.
• Develop, optimize, and maintain database schemas, queries, and models to ensure efficient data storage and retrieval. Implement high-availability strategies such as replication, clustering, and failover to minimize downtime and ensure continuous database access.
• Manage source code with version control systems and oversee deployment pipelines to facilitate continuous integration and delivery (CI/CD) across the development lifecycle.
• Create and maintain detailed documentation for codebases, database structures, system architecture, and APIs to support future development and streamline knowledge sharing within the team.
• Optimize both front-end and back-end components for performance across multiple devices and browsers, ensuring adherence to industry security standards and best practices to protect against vulnerabilities and breaches.
• Plan, create, and maintain database schemas to meet evolving business requirements and performance benchmarks. Develop and execute backup strategies, and ensure that updates, patches, and upgrades to database management systems (DBMS) are regularly applied to maintain security, performance, and compatibility.

DEV/DBA Required Qualifications:

The DEV/DBA shall possess the following minimum qualifications:

• Minimum of five (5) years of experience with IT system development and/or database administration responsibilities.
• At least three (3) years of development experience with relevant WIC MIS.
• Minimum of five (5) years of experience in front-end technologies such as HTML, CSS, JavaScript, including any frameworks like React, Angular, or Vue, as well as back-end technologies like Asp.Net, Node.js, or Java.
• Minimum of three (3) years of experience in relational (e.g., SQL Server, MySQL, PostgreSQL), along with skills in designing schemas, writing complex queries, and ensuring efficient data retrieval and storage.
• Minimum of three (3) years of experience in developing functional requirements and/or system specifications.
• Minimum of three (3) years of experience in developing report specifications.

DEV/DBA Preferred Qualifications

• Strong ability to troubleshoot, diagnose, and resolve complex technical issues in both front-end and back-end systems, ensuring optimal performance and reliability across the entire stack.
• Proficiency with version control systems like Git and familiarity with continuous integration/continuous delivery (CI/CD) pipelines for managing code and ensuring smooth deployment processes.
• Excellent communication skills, and be detail-oriented; and
• Be a self-starter and have the ability to prioritize work and multi-task.