*G**reetings from Libsys Inc!!!* *We have an immediate requirement with our direct client and the details are as follows.*
*Job Title - Sr. Database Administrator* *Location **- **Lake Mary, FL or Camp Hill, PA* *Duration - Long Term* *JOB DESCRIPTOIN:* Database Administrator · Lead in overall database tuning strategy; · Transformation of the logical data model into the physical database schema for the data mart; · Creation and maintenance of all staging tables; · Creation and maintenance of data mart tables; · Development and maintenance of the data definition language (DDL) for creating and maintaining the data mart tables; · Develop summary/aggregate tables where required to improve data mart performance; · Create solutions as required for end user access; · Identify and establish indexes to support data mart performance requirements; · Set up and maintain security on the view, table and column level; · Monitor SQL for performance impacts; · Capacity planning; · Maintain physical design for good performance; · Monitor response time and resources used (CPU, disk I/O), for evaluating performance problems; · Tune databases; · Review of complicated SQL statements written by both application developers and power users; and · Mentors State Staff. · At least seven (7) years working on large scale Data Mart / Data Warehouse projects; · At least five (5) years in the role of a database administrator in large-scale Oracle environment with databases in excess of 5 terabytes (TB); · At least five (5) years of experience installing, configuring and administering Oracle database as a data mart; · At least five (5) years of experience with data replication between databases (primary and disaster recovery); · At least five (5) years of database performance tuning with databases in excess of 5 terabytes (TB); · At least five (5) years of experience with securing sensitive data, both in-flight and at rest; · At least five (5) years of experience implementing row and column level based security; · At least five (5) years of experience with implementing security and privacy requirements in a large enterprise environments; and · At least five (5) years of experience with backup, maintenance, and data restoration. Thank You, Mowseen Mohammad, Technical Recruiter *Libsys Inc **'IT Sharps'* Direct 630-303-9917 *[email protected]| <[email protected]%7C>* www.LibsysInc.com <http://www.libsysinc.com/> -- You received this message because you are subscribed to the Google Groups "it req" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/it-req. For more options, visit https://groups.google.com/d/optout.
