Project Lead - Oracle Production Control (full time)
We are Niche Technologists, Inc. a national consulting and staffing company with a focus in the business intelligence sector.
We currently have a full-time position in NY City with one of our BI clients. A competitive base salary, bonus and generous benefits package are included and preference will be given to qualified applicants who currently live within a reasonable commute to the city.
Note that while this position works within one of the Oracle DBA groups, this position itself is not a traditional DBA position with regard to duties and functions.
Specifically, this position dies a lot of production DBA work, lots of maintenance, modify schemas, tune PL/SQL queries, optimizes stored procedures, troubleshooting, in charge of maintenance and beta production databases, will create project plans (MS Project), manage project work (must have project management experience), manage a production environment, create status reports, make sure things are completed, assign tasks, etc.
Carefully read through the Summary and Requirements section below. Apply to firstname.lastname@example.org if you are qualified and interested.
This role performs a variety of complex, technical, and analytical tasks in the production support of mission critical systems.
Manages the estimation process and develops project plans, serves in an on-call rotation with others for batch job management and answering requests from teh IT development team; receives direction from the Production Manager and functions as a Production Manager in that person's absence. This requires close liaison with the entire IT organization. Note this is a very hands-on position.
9+ years experience working with Oracle, with 3 - 4 years experience modifying schemas, optimizing queries, and performance tuning of stored procedures
Must have 1+ year experience working in Oracle 9/10
Experience monitoring job schedules and following up with failed jobs
Experience in UNIX shell scripting
Experience with Oracle query tuning, PL/SQL and stored procedures
Experience with MS Project
Experience using Autosys job scheduling is strongly preferred
Experience using Tidal job scheduling is a plus
Managing impact analysis and performance testing on different schemas and related objects
Strong analytical, organizational, problem solving skills - able to multi-task numerous projects simultaneously
Must have excellent communication skills, both verbal and written
Work hours are 10 am to 6 pm, and will participate in on call rotating support (off hours, weekends and holidays)
The work hours at 10 am to 6 pm
Must have Bachelor's degree in computer science or equivalent work experience