Vacancies

Vacancies > Job Vacancy Announcement Detail

Job Vacancy Announcement Detail


Employer: IT&E
DBA: IT&E
Address: P.O. Box 500306
Saipan, Northern Mariana Islands
96950 United States
Phone: 670-234-6600
Contact IT&E via email

Job Vacancy Announcement JVA
JVA Type: New
Island Saipan
FLSA Covered? Yes, covered
DOD related? No
PERM related? * Yes
VEVRAA related? No
Original Number of Openings: 1
Number of Openings Currently Available 1
Specific Worksite location: Chalan Lau Lau
Job Classification: Computer and Mathematical Occupations
Job Title: Senior Database Administrator
Announcement Number: 19-04-73103
Job Classification: Computer and Mathematical Occupations
Opening Date: 4/26/2019
Closing Date: 5/25/2019
Salary Range: $41018 to $67662 / Annually
Job Title: Senior Database Administrator
Job Duties: Job Summary: The Senior Database Administrator is responsible for overseeing and managing the Oracle systems and implementation, maintenance and support of the company’s application databases; perform software application programming across multiple technologies to construct software applications that perform according to business requirements and priorities; write and compile complex, multi-layer SQL statements over an Oracle database, to update production data and create reports; primarily in charge of monitoring and maintaining systems with Oracle Database as the backend; training others in using Oracle; facilitates the creation and monitoring of various internal corporate databases running in SQL Server and MySQL used by the different systems in the company. Strategize, collaborate, and participate in various monitoring, performance, and analysis tasks with the goal of performance optimizations; and review SQL queries written by software developers for performance enhancement. The Senior Database Administrator will supervise one subordinate Database Administrator. Essential Duties and Responsibilities: The Employee will: 1. Know and uphold the established IT&E Mission, policies and procedures, IT&E and Department objectives, quality assurance and safety programs and standards. 2. Oversee data analysis and database management for Oracle systems including applications upgrades 3. Lead in the implementation of enhancements of existing databases and/or creation of new databases in order to provide an optimum design that satisfies the company requirements. 4. Develop database structure, implement applications, enhance system and ensure security. 5. Perform a variety of database development and administration functions (including database stored procedures, user defined tables, views, triggers, and SQL scripts) 6. Design scripts and develop tools to automate periodic task and improve monitoring of system. 7. Author database documentation and guidelines to help support system operations. 8. Provide after hour maintenance, coordinate with consultants and manage vendors for patches and upgrades. 9. Create and maintain data dictionaries, physical databases and logical database models. 10. Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code. 11. Estimate software development timelines and be accountable to the timelines by actively managing risks and changing requirements. 12. Partner with business analysts and application super users to successfully complete projects. 13. Supervise and provide technical support and mentoring to less senior developers in order to foster professional development. 14. Work with end users to develop best practice business processes.
Qualification Requirements: Minimum Qualification Requirements: Education: Bachelor’s degree from an accredited college or university in computer science or related field. Work Experience: Five years of experience performing Oracle Database administration. Extensive working knowledge of Windows/Linux Oracle jobs, along with automation. Strong working knowledge of SQL, PL/SQL, applications development for IOS or Android, and report generation and automation.
Full or Part Time: Full Time
Hours per Week: 40
Hours per Day: 8
Payment Frequency: Biweekly
Three-fourths Guarantee 655.18(b}{17}:

"The employer may voluntarily offer the three-fourths guarantee but it is not required as a condition of placing a job order to be filed in connection with an H-2B application pursuant to 20 CFR 655.5. Three-fourths is defined as an offer to workers full-time employment for a total number of work hours equal to at least three-fourths of the workdays of each 12- week period (or 6-week period if the employment covered by the job is less than 120 days.)."
Overtime Available: No
Overtime Rate: $0
Rate x 1.5 per hour Exempted: Yes
Specify All Payroll Deductions: All federal and local taxes; all others depends if employee signs up for example 401(k), medical & dental, supplemental life, and all other benefits.
Required tools, supplies and Equipment to be provided: All tools required to do the job
Anticipated starting date of employment: 10/1/1900
Anticipated closing date of employment: 10/1/1900
Housing Provided: No
Food Provided: No
Transportation required: No
If transportation is required, daily transportation to and from the worksite(s) will be provided to the workers. Daily pick-up place(s) will be at: 0
Fringe Benefits: 401 (k) (matching up to 6%; $0.75 to a $1.00) Life Insurance (100% Basic Life) Gas Card ($0.57 off gallon at IP&E) Medical Insurance (65% of monthly premium) Dental Insurance (50% of monthly premium) Employee Telephone Discount. Workers compensation provided. Vacation & Sick Leave Benefits
Comments: All interested applicants must apply online at careers.pticom.com