Job Description :
Sr Oracle Developer
Albany, NY
24 Months

Job Description:
System Support role involves architecting and maintaining Oracle enterprise-level databases in support of computerized application systems.
The CONNECTIONS project is an ongoing effort to provide the development, maintenance, and support activities on the New York State’s Statewide Automated Child Welfare Information System (SACWIS) for OCFS, LDSS, and Voluntary Agencies
Review project/application/infrastructure initiatives and requirements
Design and Develop Oracle RDBMS solutions, options, and configurations
Advise on future applicability & suitability of architected solutions
Research Industry database trends for suitability to support systems.
Develop and enforce database & design standards
Database instance monitoring and tuning
Schema design (data modeling), development and implementation
Design, Implement, and enforce database security
Hardware/Software Infrastructure support (Oracle rdbms, server o/s); Interface with Server administrators and other technical support staff
Database Backup and Recovery procedures (Oracle RMAN, utilities, etc
Disk & Tablespace utilization, monitoring, and reorganization;
Data Management support (data refresh processes, application data fixes, Data load and/or conversion support)
Troubleshooting and problem resolution; Utilize Oracle Support as needed. Provide Oncall/after hour support as needed.
SQL (Application) monitoring, tuning and advice
SQL & PL/SQL expertise; create/ troubleshoot Oracle-based procedures.
Utilize Oracle Enterprise Mgr product to facilitate db admin tasks.
Candidates should have at least 84 months experience and a majority of the following should apply:
Each candidate should fill out the months of experience they have for each item in the table:

1. Bachelor’s degree (or higher) with major or minor in Computer Science or related field. #OF MONTHS 10
2. 84 months experience architecting technical solutions utilizing Oracle relational database technologies. Specific areas of experience are expected to include (but are not limited to): Database Instance & Multi-Schema configurations, Security, High Availability/Disaster Recovery features (RAC, Data Guard), Backup/Recovery (RMAN, Flashback), Disk configurations (including ASM, partitioning), Oracle Enterprise Mgr/Grid Control, Oracle Network setup including Dedicated and Shared server configurations. #OF MONTHS 10
3. 84 months experience participating in project system development life cycle activities to collect and organize data and database infrastructure requirements including data modeling (logical and physical), database design, hardware/software, high availability/disaster recovery, and post implementation monitoring and troubleshooting. #OF MONTHS 10
4. 84 months demonstrated experience as database administrator of Oracle Relational databases utilizing software releases 11 and 12. Experience must include but not limited to performance of the following: software installation, database instance creation, schema design (data modeling) and creation (DDL), tablespace management, backup and recovery, data management utilities (data pump, sql loader, etc, sql tuning skills, and SQL/Pl-SQL. #OF MONTHS 10
5. 60 months demonstrated experience installing, configuring, and utilizing the Oracle Enterprise Manager product versions 11 and 12 to support the administration and monitoring of Oracle databases and overall Oracle infrastructure. #OF MONTHS 10
6. 84 months experience working with UNIX. Experience should
include operating system principles, system/ server admin staff on database and application related issues,
and shell scripting to support automation of database tasks. #OF MONTHS 10
7. 12 months demonstrated experience monitoring, supporting and helping to administer Informatica IIR/SSA search software. #OF MONTHS 10
8. 36 months demonstrated experience supporting Oracle interfaces for computer applications utilizing Microsoft .Net Framework 2.0 or higher. #OF MONTHS 5
9. 36 months demonstrated data processing experience working in public/government sector IT applications dealing with the delivery of government assistance or entitlements. #OF MONTHS 5
             

Similar Jobs you may be interested in ..