Information Technology Specialist 3 (Special Expertise) - Item #47217
No Current Vacancies for Information Technology Specialist 3 (Special Expertise) - Item #47217
Applications accepted from current State employees and former permanent competitive class employees eligible for reinstatement. You must meet the minimum qualification.
|Posting Specific Information|
|Application Due By|
|Title||Information Technology Specialist 3 (Special Expertise) - Item #47217|
|Location: City DEC Region Division/Bureau|
|Work Days||Mon. - Fri.|
|Employment Type||Temporary Budgeted Item|
|Bargaining Unit/MC||PS&T 05 (PEF)|
|Duties/Responsibilities||Under the direction of the Database Administration Unit Manager, this position is responsible for administration of the DEC's enterprise Oracle databases. The incumbent must have advanced knowledge of Oracle 11g and is expected to perform a full range of DBA responsibilities with minimal supervision. Frequent interaction with the data modeler and developers is common and the DBA is expected to understand and adhere to agency standards and industry best practices. The DBA will often work with network staff, developers and users when addressing problems. Additional duties include:
Working with the Data Modeler and other project team members, determines user requirements, designs the physical database, creates the database, tests and coordinates changes.
Interacts with development and user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent information required to develop and maintain integrated databases. Calculates and establishes physical database parameters.
Establishes security access levels for users or groups of users.
Using available tools, monitors database performance and makes improvements through performance tuning.
Tests and corrects database errors as necessary. Identifies changes that should or must be made to applications or database and communicates these to developers and analysts.
Reviews requested changes to database, analyzes and reports possible affects, and then coordinates agreed upon physical changes to databases.
Reviews scripts and programs for accuracy and efficiency and, if appropriate, corrects the errors.
Works with users and developers to answer questions about the database
Strictly adhered to based on
Civil Service requirements
5+ years experience as an Oracle Database Administrator in a UNIX environment, including at least two years experience working with Oracle 10g or 11g, applying Oracle software patches, including Critical Patch Updates or Patch Set Updates, Oracle Enterprise Manager GRID, and writing SQL.
Also requires in-depth knowledge and experience of: database backup and recovery using RMAN; database creation and creation of database objects (tables, indexes, keys, triggers, views); monitoring server performance; database performance tuning based on evaluation of performance statistics (CPU usage, memory usage, disk usage); tuning SQL statements using Explain Plan; Gather Stats; and upgrading a major Oracle release.
Qualified candidates should forward a resume and/or Employment Application which clearly indicates how the minimum qualifications are met and includes the Control Number. If you are applying for more than one posting, you must submit a separate resume or Employment Application for each control number. Send to:
If you are a permanent NYS employee not employed by the Department of Environmental Conservation or applying for reinstatement, please provide your social security number so that appointment eligibility may be verified.
State Employees: If you wish to receive an acknowledgement that your application for this posting was received by the Bureau of Personnel and then receive information on the disposition of the position, please attach two self-addressed stamped envelopes (preferably inter-office or inter-agency) to the application. If you are applying for more than one position, you must include two envelopes for each position.
Some vacancies may be anticipated and may not result in an appointment. Application for any position listed may not result in an interview