Resolvit Resources, LLC
As the Senior Oracle Database Administrator , you will test, validate, and implement performance and resource optimization improvements in consultation with data warehouse development and support team. You will maintain development and production environments and monitor and maintain database stability, security, growth, and performance of the data warehouse environment. You will also resolve problems in data warehouse bottleneck areas with approaches to wait event tuning, session blocking, SQL and index tuning, and SQL profiles. Additionally, you will: Automate monitors of scheduled batch jobs and queues including any adhoc activities: run command line, shell scripts, SQLs, run scripts, monitor queues, connect to various servers, and verify the results Evolve the data warehouse environment within the organization, including better information delivery mechanisms, methodologies, and architecture Participate in on-call for production database rotation - daily maintenance, monitoring, problem resolution, and internal customer\/dev support Review, design, and develop data models in conjunction with the application development teams Design, develop, and implement Oracle data warehouse instances for the development and production environments Provide advice to Software Engineers on the effective use of Oracle features and provide advice on troubleshooting, exception processing needs, and other data management issues Design logical data models, physical database structures, and DDL and DML scripts as required Provide database performance tuning - optimizing databases for performance Supervise the technical implementation of the data warehouse and oversee hardware\/ software configuration What You\u2019ll Need to be Successful: A minimum of 5 years of experience in a data warehouse environment Bachelor or graduate degree in computer science or a related field Strong background in data warehouse concepts\/strategies Working knowledge of Oracle DBA best practices (schema management, index optimization, and use of hints) Capacity monitoring and management capabilities Expert knowledge in Dimensional Modeling Knowledge of Oracle 11g, 12c instances on consolidated, RAC, and Exadata Great Additional Skills: Experience with Oracle Exadata, Big Data Appliance, 12C, EBS, RMB, OIM, GoldenGate, ZFS, Data Guard, TDE, and Data Warehousing Experience working with Oracle database instances in an AIX HA and\/or Linux RH environment Strong query and database tuning skills Extensive UNIX shell scripting, PLSQL, and SQL skills Highly motivated to solve problems efficiently Fast troubleshooting and resolution skills Extensive experience with very large data warehousing systems Ability to manage multiple tasks with shifting priorities Ability to build and maintain strong working relationships with DBA and application teams Excellent communication and presentation skills Benefits: At Resolvit, you\u2019ll be given the support you need to grow in your consulting career. In addition to opportunities for advancement and ongoing training, we offer: Medical, dental, and vision insurance Life insurance coverage Long-term and short-term disability coverage 401(k) retirement plan with matching Professional support from a dedicated Business Services Manager Networking opportunities with other consultants in your area We currently have more than 100 open career opportunities across the country, so be sure to mention the appropriate Job Code with any correspondence!
Resolvit Resources, LLC
Website : http://www.resolvitresources.com/
Resolvit LLC is a fast-growing IT and management consulting firm that combines the deep experience and bench strength of larger systems integrators with the focus, dedication and responsiveness of a nimble, customer-driven operation.