NJ Department of Environmental Protection-posted 4 days ago
Full-time • Entry Level
Trenton, NJ

Under general supervision in one of the Data Centers, is responsible for the analysis, physical design, coding, testing, migration, and implementation of databases in various platforms; coordinates efforts with systems and programming staff assigned to application development projects; creates and updates data dictionaries for applications; does other related duties as required. Specific to the Position Serve as the primary Database Analyst/Administrator (DBA) for assigned database systems and backup DBA for systems covered by other DBA staff. Manage the OS on the Linux database servers and ensure appropriate patch levels for the Linux OS, Oracle, SQLServer, MariaDB and other RDBMS software. Determine the logical and physical organization of data to meet storage and processing requirements of systems, document the design. Review data requirements for application systems and defines appropriate database/data dictionary structures. Code, test, and implement specialized routines for loading, accessing, retrieving, and updating for database applications. Manage redundancy and backup implementations. Manage resource allocations among multiple database servers to ensure efficient utilization of resources and monitor licensing compliance for software and applications. Test and advise on database version upgrades. Provision testing and development of databases as necessary.

  • Analysis, physical design, coding, testing, migration, and implementation of databases in various platforms
  • Coordinates efforts with systems and programming staff assigned to application development projects
  • Creates and updates data dictionaries for applications
  • Serve as the primary Database Analyst/Administrator (DBA) for assigned database systems and backup DBA for systems covered by other DBA staff
  • Manage the OS on the Linux database servers and ensure appropriate patch levels for the Linux OS, Oracle, SQLServer, MariaDB and other RDBMS software
  • Determine the logical and physical organization of data to meet storage and processing requirements of systems, document the design
  • Review data requirements for application systems and defines appropriate database/data dictionary structures
  • Code, test, and implement specialized routines for loading, accessing, retrieving, and updating for database applications
  • Manage redundancy and backup implementations
  • Manage resource allocations among multiple database servers to ensure efficient utilization of resources and monitor licensing compliance for software and applications
  • Test and advise on database version upgrades
  • Provision testing and development of databases as necessary
  • EDUCATION: Graduation from an accredited college or university with an Associate's degree in Computer Science, Information Technology, or a closely related field.
  • EXPERIENCE: Three (3) years of systems analysis, applications programming, design, systems programming and/or database administration or analysis experience in the data processing field, one (1) year of which shall have been in database design, analysis, and/or implementation.
  • NOTE: A general Bachelor's degree can be substituted for one (1) year of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
  • NOTE: A specific Bachelor's degree in Computer Science, Information Technology, or a closely related field can be substituted for two (2) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
  • NOTE: A Master's degree in Computer Science, Information Technology, or a closely related field may be substituted for three (3) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
  • Special Note Substituting Experience for Education: Experience in the study of work methods and processes, the analysis of varied types of data, the design and preparation of systems and programs, the operation of multi-tiered computer systems and work in the data processing support areas of reporting or reliability support may be substituted for the required education on a year-for-year basis with thirty (30) semester hour credits being equal to one (1) year of experience.
  • NOTE: Evidence of formal training in Computer Science or Information Technology received from or evaluated by an accredited institution of higher learning may be submitted with your application. Applicants must provide documentation from the accredited institution that clearly outlines the training course(s) that are acceptable and the corresponding number of credit hours for the training to be accepted. In-house courses (such as training provided on the job or through the appointing authority) will not be accepted.
  • NOTE: All U.S. degrees and transcripts must be from an accredited college or university. All foreign degrees and transcripts must be evaluated for accreditation by a recognized evaluation service by the closing date of this posting. Failure to provide documentation may result in ineligibility.
  • Appointees will be required to possess a driver's license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform the essential duties of the position.
  • Preference will be given to candidates with experience in Oracle RDBMS, Microsoft SQL Server, MySQL/MariaDB and/or other enterprise RDBMS solutions, knowledge of Structured Query Language (SQL) and advanced database management concepts, experience in RMAN backup, Data Guard, Transparent Data Encryption, Label Security, and Enterprise Manager(OEM), familiarity with Windows Operating System and Linux, as well as maintenance of essential records, documentations, and files.
  • Paid Benefit Leave
  • Holiday Pay
  • Alternative Workweek Program
  • Telework
  • Pension
  • Deferred Compensation
  • Health Benefits (medical, prescription drug, dental & vision care) and Life Insurance
  • Flexible and Health Spending Accounts (FSA/HSA)
  • Commuter Tax Savings Program
  • Public Service Loan Forgiveness (PSLF)
  • Tuition Reimbursement
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service