Urgent requirement:DB ADMIN

Hi ,

 

Please do let me know your comfort levels on this requirement ASAP.

 

DB ADMIN,  Baltimore----> Long Term Contract.

 

This position involves highly technical work of considerable difficulty and will function as the only onsite resource for the planning, designing, implementing, and maintaining Oracle, MS SQL & DB2 Databases for: Oracle H.R. application; Financial Data Warehouse (FDW); Accounting Financial Reporting of Grants System (AFR Grants); 48 SQL instances including a 32 SQL cluster instances, and DB2 database reporting system.

 

The DBA will apply updates, modify security, and develop procedures, as needed, to allow authorized staff access to the database.  The DBA will have considerable latitude in administering this complex and sensitive area of responsibility. Responsibilities include monitoring performance of Financial Data-Warehouse and AFR Grants Oracle databases and MS SQL databases, administering policies, and developing functional procedures. The DBA recommendations and decisions will affect the administration and management of all divisions within the organization.  The following are additional roles and responsibilities:

 

A)    Identify and resolve performance problems involving the applications databases and associated hardware.

 

B)     Work with network support staff to troubleshoot connectivity issues.

 

C)     Define system specifications, analyze malfunctions and develops solutions.

 

D)    Assure maximum utilization of existing hardware and resources.

 

E)     Establish and maintain operational procedures and practices.

 

F)      Maintain database security.

 

G)     Develop and monitor backup strategies.

 

H)    Manage, plan, and configure data view for front-end processes.

 

I)       Assist in setting long-range plans and goals for performance.

 

J)       Design, update and implement new scripts and applications.

 

K)    Provide operational and technical guidance as required.

 

L)     Interact with developers on SQL, Oracle and DB2 support teams.

 

M)   Develop and update reports using Cognos ® reporting tools.

 

N)    Manage and support the entire data integration lifecycle using Informatica ®.

 

O)    Develop and update reports using Microsoft Crystal Report and SQL Report.

 

P)     Oracle 10G DBA:  Perform database upgrades; Table-space and storage management; database reorganization through export/import; database backups, recovery and restoration; Schema management including tables, indexes and partitions; resolving table locks; performance tuning including Oracle memory tuning; monitoring and fixing system issues; managing roll back segments; extent management; troubleshooting database errors; monitoring database growth; resolving user errors; Oracle WebDB administration tasks; Coordinate with the application vendor for application specific issues; TAR management and applying patches.

 

Q)    SQL 2005 Server DBA administration:  Responsible for SQL Server 2005 and SQL 2005 Active/Active Clustering administration; Daily monitoring of backups; restoration of databases; recovery of databases; creation and administration of new databases and user logins/permissions; monitoring data and transaction log file growth; resolving user issues and coordination with application vendors; SQL logs monitoring; creating test SQL environment for vendors/users; using DTS for data migration.

 

R)     R*Stars refresh Administration (R*Stars is a proprietary State tool with this link having more information about it: http://compnet.comp.state.md.us/General_Accounting_Division/Static_Files/rstars_training.pdf) The R*Star refresh uses FTP to receive a file each weekend from the Maryland State Comptroller's Office containing a complete copy of the agency financial information contained in the R*Stars in formation stored at the Comptroller's Data Center.   Each week after it is received, the R*Star file with the agency information is used to refresh the Financial Data Warehouse. Since, the legacy CISC application at the Comptroller's Office has limited reporting abilities, the Management Staff use Cognos and the Financial Data Warehouse to produce AHOC reports.  At the start of each week, the DBA will verify and monitor the weekend R*stars refresh process and ensure that the data warehouses are updated properly and accurate; Troubleshoot and resolve issues with Informatica Power Center & Designer 8.5.1; Interact with Annapolis Data Center (ADC) for issues with file transfer process; manage data transformation process and fixing errors; Follow up with users to ensure all encumbered grants in R*Stars populate to Grants database and troubleshoot missing grants. The RStar Refresh occurs each week after populating the Financial Data Warehouse, the DBA will execute scripts to build files to distribute warrant data to Remote sites at the Work Force Technology Center and Disability Determination Services where the local staff at each facility will import the data.

 

S)      Cognos® Impromptu and Impromptu Web Reports Administration 7.3:   Regular administration of R*Stars and Grants catalogs; create Impromptu reports and publish in Impromptu Web Reports for user access; Impromptu report modifications and format changes and republish through Cognos Distribution Shuttle Builder.

 

T)     Cognos® Impromptu Server Administration 7.3:   Coordinate with Windows server administrators; administer various Cognos processes for Impromptu, Impromptu web reports, Cognos Powerplay, Directory Server; Troubleshoot and fix user errors; Monitor user requests and system performance.

 

U)    Oracle 10G Applications server portal Regular database backups, db recovery and restoration; table-space and data-file management; Logical database backups using export/import utilities; Database refreshes from production to test instances; oracle system administration tasks; patching when required; TAR management; Loading regular and contractual payroll files into Oracle through SQL*Loader; Coordinate with Oracle Consultant.

 

V)    Other non-regular task:  Create files by extracting data from the Financial Data Warehouse and use FTP to distribute files to other networks for their processing including Vendor table information and warrant interface information.  Scripts to create these files are scheduled to execute every week. Maintain a DB2 Express 9.1 instance of Administration Tracking system DB2 database. Work with iPlanet Directory Server 5.1 (LDAP) and Microsoft IIs Web server 6.0.

 

W)   Financial Data Warehouse System (FDW):  Maintain the financial accounting data stored in Oracle database designed for end user querying and reporting. This mega database is populated by a series of processes that begin on the R*stars mainframe system. COBOL programs extract data from DB2 tables and data transformation and loading into FDW Oracle tables is done through Informatica Powermart. During every weekend, the R*stars refresh process is completed and so by the beginning of the week, the datawarehouse is up-to-date with data from the previous week.  The users access the warehouse through Cognos Impromptu and Cognos Powerplay tools.

 

X)     Grants AFR:  The Grant AFR application is used to manage grant revenue and expenditure amounts based on the grants awarded to LEAs and financial reports submitted by LEAs to the Agency. This Oracle database is an Online Transaction Processing (OLTP) system and supports grants creation, updates for data entry as well as report generation. This system is also fed from FDW for R*stars data and includes two types of subgrantee payments, federal fund (type one) and general fund (type two) which are interfaced to R*Stars. Users access this system through Cognos Impromptu and Cognos Impromptu Web Reports.

 

Y)    Oracle 11i E-Business suite (Oracle Financials) HR:  :  This Proprietary COTS System is used to track leave balances for all staff.  This Oracle database is an Online Transaction Processing (OLTP) system and supports leave computations and payroll functions, This system interfaces with the Budget process, the State's Payroll System, FDW for R*stars data.   

 

Z)     Agency Upgrades: They will upgrade to Oracle 11G Database server, Oracle 12G Application Servers, SQL 2008 database & cluster, and Cognos 8.

 

 

 

 

 

DBA Minimum Qualifications and Certifications

 

Bachelor's degree (Master's degree preferred) and have at least six (6) years of practical experience as a senior DBA resource, including certifications as an Oracle and / or Microsoft SQL Database Administrator.

The required experience must be in the following technical areas:

 

A)    Working knowledge of a Database  environment

 

B)     Windows Server 2003 and 2008

 

C)     Active Directory

 

D)    Oracle^® Data Base Administration

 

E)      Oracle^® Applications

 

F)      MS SQL^® Data Base Administration

 

G)     MS SQL^®  Clustering Administration

 

H)    Cognos^® Impromptu and Impromptu Web Reports Administration

 

I)       Cognos^® Impromptu Server Administration

J)   DB2 experience

 

Looking forward to work with you.....

 

Regards,

 

Gary Reddy

972.550.9346 x 208

gary.r@itcell.net