About the Opportunity
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- We are only considering local candidates who currently reside within 45 minutes of postal code 08625
- No Third Party Agencies
- $77.22 per hour 1099, $66.33 per hour (W2 - Benefits), or $59.4 per hour (W2 + Benefits)
- 100% Work from home in Trenton, New Jersey
- Job Id: CAI-746957
- Must be able to provide proof of COVID-19 vaccination plus booster shot
- Contract Term: Till end of the 2025 fiscal year with extension based upon performance
- Hours per week: 40
Short Description
The State of New Jersey’s Treasury Department is seeking an Oracle/SQL Server DBA augment and support of the NJ Treasury Database staff in the daily database administration. The ideal candidate will possess 5+ years of experience managing Oracle DB and client requirements as an admin, 4+ years of experience managing databases on Unix operating systems, and 4+ years of experience managing databases on Windows operating systems.
Required Skills/Years of Experience:
- Bachelor's Degree in IT or related field or equivalent experience
- 5+ years of experience managing Oracle DB and client requirements as an Admin
- 4+ years of experience managing database on Unix operating system
- 4+ years of experience managing database on Windows operating system
- 3+ years of experience migrating Oracle 12c - Oracle 19c
- 3+ years of experience writing shell scripts for automation of backup scripts
- 3+ years of experience with Oracle 12 c and Oracle 19c archive scripting
- 3+ years of experience with Oracle 19c migration testing
- 3+ years of experience documenting database migration activities
Desired Skills/Years of Experience:
- 2+ years of experience migrating SQL server database 2014 to SQL Server 2019 database
- 2+ years of experience testing and validating Always on migration 2014 to Always on 2022
- 2+ years of experience with SQL Server Administration
Complete Description
The State of New Jersey’s Treasury Department is seeking an Oracle/SQL Server DBA augment and support of the NJ Treasury Database staff in the daily database administration. The ideal candidate will possess 5+ years of experience managing Oracle DB and client requirements as an admin, 4+ years of experience managing databases on Unix operating systems, and 4+ years of experience managing databases on Windows operating systems.
The Oracle/SQL Server DBA will be tasked to:
- Augment and support the NJ Treasury Database staff in the daily database administration
- Assist in the migration and upgrade of Oracle and SQL Server databases
- Support and assist in all aspects of the Treasury database tasks such as managing clients requirements, testing and validating, and documentation
- Write shell scripts for automation of backup scripts
- Maintain responsibility for data analysis and database management
- Be involved with maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning
- Demonstrate knowledge of the utilities and production tools used for data storage management to support the application team
- Coordinate physical changes to computer databases, codes, tests, and implements physical database, applying knowledge of database management system
- Design logical and physical databases reviews description of changes to database design to understand how changes to be made affect physical database
- Establish physical database parameters
- Use structured query language (SQL) to define database objects using database definition language (DDL) and control access to database objects using data control language (DCL)
- Calculate optimum values for database parameters, such as amount of computer memory to be used by database, following manuals, and using calculator
- Specify user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data
- Specify which users can access databases and what data can be accessed by user
- Test and correct errors, and refines changes to database
- Use database utility programs and 3rd party utilities to monitor database performance, such as distribution of records and amount of available memory
- Modify database programs to increase processing performance, referred to as performance tuning
Hiring Expectations
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- No Third Parties
- Right to Represent authorization is required
- Expect technical interview screening
- Expect F2F interview
- Background checks and verifications will be required
About Dantech
Dantech Corporation, Inc. is a Certified Business Enterprise (CBE) in the District of Columbia and a federally recognized Woman Owned Small Business (WOSB). The company has a history of technology, innovation and transformation since its launch in 1999. As an Equal Opportunity/Affirmative Action Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, or disability status. For more information, please see: www.dantechcorp.com.