*Oracle & SQL Server DBA* *Location: Tallahassee, FL* *Duration: 1 year*
*Send The Resumes to z...@shstinc.com <z...@shstinc.com>* *MUST Have worked with State Government project before, especially if they have worked at the State of Florida or other state Department of Health.* Required Skills o Oracle Related Experience • 6 or more years’ of experience with Oracle products inclusive or Oracle Database Server, Oracle Application Server, Oracle Streams, Oracle Data Guard, Oracle Grid Control, and Oracle RMAN. • 6 or more years’ of experience with PL/SQL programming. • 6 or more years’ of experience with Oracle relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments. • 6 or more years’ of experience with Source Code Control System (SCCS) for the management of internal code changes to Oracle Forms/Reports, Oracle objects, and scripts. • 6 or more years’ of experience with development and maintenance of Perl scripts and UNIX shell scripts. o MS SQL Related Experience • 6 or more years’ of experience with MS SQL products inclusive of MS SQL 2008. • 6 or more years’ of experience as an MS SQL administrator inclusive of data design/modeling, monitoring, and performance tuning. • 6 or more years’ of experience with SQL programming inclusive of stored procedures, functions, triggers, DTS packages, scheduled jobs, and linked servers. • 6 or more years’ of experience with SQL relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments. • 6 or more years’ of experience with configuration management (SourceSafe administration) for SQL database objects. • 6 or more years’ of experience with database design tools including ERWin and ERStuido. Job Description • Modify the FL DOH Licensure application code (i.e. COMPAS/Versa); • Modify ORACLE PL/SQL language; • Modify database storage structures (table spaces); • Design model objects (tables, views indexes); • Monitor and optimize the performance of the licensure database; • Develop ad-hoc queries on database schema; • Modify MQA Service Portal Application DB objects; Modify MSSQL T-SQL language; • Modify MSSQL Database Storage structures tables; • Modify MSSQL tables view indexes; • Monitor and optimize the performance of MQA Services Portal Database and Application Server; • Develop ad-hoc queries on MSSQL Databases; • Provide analytical services for system incidents and enhancements; • Process defect tickets to correct system errors within one (1) to two (2) business days; • Process release tickets to manage user requirements within the timeframe directed by the specific ticket request. The response (due) date of tickets assigned will range from one (1) hour to more than one (1) week; • Process change tickets to implement system changes on a weekly basis; • Provide change management in a code promotion role in partnership with development team; • Provide analytical services on systems to implement user-defined requirements; • Provide analytical services on systems to identify operational efficiencies; • Facilitate collecting system requirements with the business program staff; • Document system technical objects, business requirements, business processes, and system processes; • Test application code; • Test database code objects; • Test database design objects; • Perform testing on system changes to meet user-defined requirements; • Facilitate user acceptance testing (UAT) with the business program staff; • Facilitate meetings with technical and program staff (scheduling meetings, document decisions, identify issues and action items); • Produce work estimates to implement user-defined requirements and system changes; • Produce status reports on the implementation of user-defined requirements; • Produce detailed accounting of hours worked by tasks; • Provide analytical services on DOH IT processes to identify operational efficiencies; • Provide analytical research to satisfy queries requested by the Legislature and DOH management; • Follow DOH IT processes and coordinate with other DOH IT staff to ensure compliance with DOH standards; and • Correspond (verbally and in written formats) with project teams, internal stakeholders regarding project activities, deliverables, and status Regards, Zaid Mohammed 412-450-1316 Ext:111 Seven Hills Software Technologies Inc -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
