I have a very urgent DIRECT CLIENT requirement for Oracle DBA in Richmond,
VA. Please Let Me Know If you have available candidate, please reply with
their word resume, location, rate and contact number.

Please send the resumes at su...@cncconsulting.com

Job Title: Oracle DBA
Location: Richmond, VA
Duration: 10 months

In person interview

VDOT- IT uses a Pavement Management System (PMS) and a Pavement Maintenance
Scheduling System (PMSS) to guide Our client’s most significant investment
areas; the analysis and management of nearly 126,000 lane miles roads and
highways.  These systems support the collection and analysis of current
pavement data and provide an integrated method for annually scheduling the
required maintenance work.
The scheduling of pavement improvements in the PMSS depends on a number of
technology solutions which have yet to be developed and implemented to
better integrate PMS and PMSS.  These systems rely on a heavily normalized
set of Microsoft SQL Server and Oracle databases, making analysis and
reporting of data by the end user difficult.  In addition, the PMS
application relies on SQL to perform many of its functions and
calculations.  As the needs of the PMS Users change, modification of this
SQL code must take place to accommodate these needs.  The PMS application
also depends on the import of data from other internal and external
systems.  Import routines frequently need to be developed or modified to
accommodate new or changing data import requirements, and to provide the
functionality necessary to insure that imported data meets the user’s
quality assurance requirements.
VDOT- IT has need of a person who can develop technology solutions to
better meet the Maintenance Division business needs and improve integration
of PMS with PMSS.
Note: As is often required in support of 24 X 7 Production applications,
on-site participation in implementation activities outside normal working
hours is to be expected.

Responsibilities:
*local candidates strongly preferred
*the client will conduct ONLY in-person interviews, NO Skype, NO exceptions
VDOT- IT seeks an Oracle Database Administrator to support mainly the
Pavement Management System and other databases. This individual will be
responsible for
Installing Oracle software and designing, creating and administering the
databases.
Work with the team to ensure that the associated hardware resources
allocated to the databases and to ensure high availability, security and
optimum performance.
Assist Development teams to improve the performance of SQL and Databases.
Creation & maintenance of tables/Columns/Indexes to ensure that the
designed applications are functional and perform well.
Work with the team to ensure that the associated hardware resources
allocated to the databases and to ensure high availability and optimum
performance.
To proactively monitor the database systems to ensure secure services with
minimum downtime.
Responsible for providing trend analysis to the service management team to
enable them to make informed decisions regarding resource management.
Responsible for improvement and maintenance of the databases to include
Deployments and upgrades.
Responsible for implementation and release of database changes as submitted
by the development team
Responsible for security and non-security patches based on company approved
maintenance schedules
Other duties as requested

Skill Required / Desired Amount of Experience
Bachelor’s degree in IT (Computer Science, Information Systems, etc.)  or
related field.
Minimum of 10 years experience in Oracle Database design,  development and
Administrative support with different operating system level, Windows,
Unix, Linux
Minimum of 8 to 10 years  experience in Oracle Relational Database 10g, 11g
and 12c (optional) including administer Relational databases, Schemas,
Indexes, views, materialized views, synonyms, procedures & database
triggers
Knowledge of Oracle spatial data procedures and concepts is preferred,
Highly desired of 5 to 6 Years
Minimum of 8 Years of experience with Oracle technologies ( Security,
Partitioning, SQL and DB Performance Tuning, Memory Management, statistics
gathering, auditing)
Minimum of 5 years experience in Oracle RAC Administration, ASM, AWR, Data
guard, Standby databases and Grid Control Administration.
Minimum of  5 years experience in Backup and Recovery  using RMAN  in
Oracle 10g or higher versions
Minimum of  5 years experience in problem solving techniques and other
database related issues, Ability to quickly learn new business and
technical concepts in a fast paced service focused environment
Ability to analyze and tune complex update or selection queries against
very large data sets, develop server-side PL/SQL, Procedure, Functions and
Triggers using Oracle new features for complex architecture
Required  minimum of 5 Years
Highly motivated with the ability to work well independently and within a
team environment and ability to cope well under pressure
Knowledge of  using SQL Developer and TOAD, Erwin and any other tools
Required 8 Years
Familiarity with Microsoft SQL Server 2008 or later, SSIS, and T-SQL is
optional
Familiarity with JDBC connectivity concepts Required 4 Years
Proficient in Microsoft Office, including Word, Excel, and Access Required
4 Years
Demonstrated planning and organizational skills Required 8 Years

Oracle Realtional Database design, development and Administrative support
with different operating system level, Windows, Unix, Linux Required 10
Years
Oracle Relational Database 10g, 11g and 12c (optional) including administer
Relational databases, Schemas, Indexes, views, materialized views, syno
Required 8 Years
Oracle spatial data procedures and concepts Highly desired 5 Years
Oracle technologies ( Security, Partitioning, SQL and DB Performance
Tuning, Memory Management, statistics gathering, auditing) Required 8
Years
Oracle RAC Administration, ASM, AWR, Data guard, Standby databases and Grid
Control Administration. Required 5 Years
Backup and Recovery using RMAN in Oracle 10g or higher versions Required 5
Years
problem solving techniques and other database related issues, Ability to
quickly learn new business and technical concepts in a fast paced service
Required 5 Years
Ability to analyze and tune complex update or selection queries against
very large data sets and complex architecture  Required 5 Years
ability to work well independently and within a team environment and
ability to cope well under pressure  Highly desired 8 Years
Knowledge of using SQL Developer and TOAD, Erwin and any other tools
Required 8 Years
Microsoft SQL Server 2008 or later, SSIS, and T-SQL  Desired 2 Years
Familiarity with JDBC connectivity concepts  Required 4 Years
Having Oracle Certified Training Nice to have 5 Years
Adequate Experience in supporting 24x7 production environments Required 5
Years
Demonstrated planning and organizational skill Required 8 Years

Thanks,

Sunny Roy
480-463-3006  Phone
su...@cncconsulting.com

-- 
You received this message because you are subscribed to the Google Groups 
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to oraapps+unsubscr...@googlegroups.com.
To post to this group, send email to oraapps@googlegroups.com.
Visit this group at http://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/d/optout.

Reply via email to