This job ad has been posted over 40 days ago...
0

applicants

Full-time SQL Performance Tuning Expert

at Modis, Inc. in California | CA Jobs

Skills: Bachelors Degree, DB – Oracle,DB – SQL
Location: Elk Grove, CA
Oracle Database Administrator
We are seeking an experienced Database Administrator to work in a very fast pace and
extremely challenging database environment. Qualified candidates will be responsible for
working with cross-functional and cross-organizational teams to understand, augment, and
implement the databases, processes, tools, that are used in our quality manufacturing business.
The purpose of the role is to ensure that our databases are managed with the highest level or
pro-active management, maximizing uptime and performance for one of the most demanding
mission critical manufacturing systems in the world.
Key responsibilities and activities
ESSENTIAL FUNCTIONS:
The Database Administrator (DBA) is responsible for effective installation, administration and
maintenance of management information systems. Communicates effectively in both oral and
written forms; interact with users and office staff in non-technical, clear terms; assist staff with
difficult technical tasks, including the creation of specialized reports; works independently and as
a team member; set priorities and organize work to meet strict deadlines; make decisions on a
variety of complex matters; establish and maintain cooperative working relationships with those
contacted during the course of work; research and evaluate computer applications and database
server hardware and software; manage hardware/software configurations including set-up,
maintenance, and back-up. Ability to adapt to changes, self motivated and multitasking in very
fast pace environment are key success factors for the right candidate.
Assists the team in developing procedures, forms, exhibits, and database documentation;
configures hardware and software utilized on database; understands applications and how they
connect using ODBC/JDBC and other methods of connectivity; assists production support in
database reports and analysis; trains and provides technical direction to contract staff as
needed; supports internal operations, local area network administration, budget management,
and project planning.
Engineering and Provisioning
• Prior hands on experience in Very Large Multi-Terabyte Databases (VLDB) environment
01/04/2010 WW BPR & BI
• Strong experience with SQL, PL/SQL performance tuning. Good working knowledge with
stored procedures, triggers, functions, packages, UNIX Shell scripting, Partitioning, and
Indexes
• Excellent experience in installations, configurations, administration, and tuning of Oracle 10g,
11g, and ASM for high available databases
• Experience implementing ETL process, Oracle Streams replication, MV Replication, Database
Security using security compliance auditing, and bulk loading of data from flat files using
SQL* Loader preferred
• Strong experience in migrating databases from 10g to 11g.
• Develop and maintain installation, configuration and operational procedures.
• Contribute to and maintain system standards and consistency across production databases.
• Research and recommend innovative, and where possible automated approaches for
database administration tasks. Identify approaches that leverage our resources and provide
economies of scale.
Operations and Support
• Excellent experience in Oracle RAC is required and prior working experience with Exadata
Technologies is a plus.
• Previous working experience with replication technologies such as Stream Replication or
Golden Gate.
• Familiar with different Backup and Recovery strategies, Cloning (using Recovery Manager —-¿
RMAN), creating RMAN scripts, VERITAS Net Backup, Export / Import, DataPump, TTS, and
Hot and Cold back-ups
• Experience with new Oracle features: Flash-Back Recovery, DataPump, ASM, ASH, AWR,
ADDM, ASSM, AMM, ASMM, Automatic Undo management, OEM Grid Monitoring and Recycle
Bin
• Experienced in Oracle Support (raising SR) processes for technical requests through MetaLink
• Tracked record with documentation of Oracle database operations
• Fulfill DBA daily activities to include schema, user management (creating users, synonyms,
privileges, roles, quotas, tables, index, sequence, etc.); space management (tablespace and
roll—-¿back segment), monitoring (alert log, memory, disk I/O, CPU, and database
connectivity), scheduling jobs, and UNIX Shell scripting
• Monitor the performance and tuning of UNIX Servers using TOP, PRSTAT, VMSTAT, IOSTAT,
NETSTAT, GLANCE, TOPAS, NMOM, and SAR
• Perform daily system monitoring, verifying the integrity and availability of all database, server
resources, systems and key processes, reviewing system and database logs, and verifying
completion of scheduled jobs such as backups and Materialized View refreshes.
• Perform regular security monitoring to identify any possible intrusions.
• Create, change, and delete user accounts per request.
• Provide Tier II/other support per request from various constituencies. Investigate and
troubleshoot issues.
01/04/2010 WW BPR & BI
• Repair and recover from logical corruption or database failures. Coordinate and communicate
with impacted constituencies.
Maintenance
• Apply DB patches and upgrades on a regular basis, and upgrade administrative tools and
utilities. Configure / add new services as necessary to keep all factory environments
consistent.
• Perform periodic performance reporting to support capacity planning.
• Perform ongoing performance tuning, index management, and resource optimization as
required.
PROFILE:
• Bachelor (4-year) degree, with a technical major, such as engineering or computer science.
• Oracle Certified Professional in 10G or 11G.
• Excellent experience with minimum 6 years of providing 24×7 support for Production and
Development environments
• Must be an advanced troubleshooter.
• Must be a fast learner and able to learn.
For consideration, please send your resume in MS Word to amber.cloyd@modis.com.



Recent jobs at Modis, Inc.
Full-time Network Analyst at Modis, Inc. in Florida | FL Jobs 18-02-2014
Full-time Citrix Guru - Infrastructure Analyst III at Modis, Inc. in Missouri | MO Jobs 18-02-2014
Full-time Contract Recruiter at Modis, Inc. in Missouri | MO Jobs 18-02-2014
Contract Entry Level IT Business Analyst - great position for a recent graduate! at Modis, Inc. in Missouri | MO Jobs 18-02-2014
Full-time Junior Oracle DBA at Modis, Inc. in Illinois | IL Jobs 18-02-2014

« Go back to category
Is this technology job ad fake? Report it!   
Recommend to a friend
Published at 18-02-2014
Viewed: 320 times