sr. Oracle Engineer
USM Business Systems - Chantilly, VA

This job posting is no longer available on Dice. Find similar jobs: Senior Oracle Engineer jobs - USM Business Systems jobs

Direct client requirement USJCB1154 Oracle Principle Engineer (12GSS082) Location Chantilly VA Duration90 business day temptoperm Positions1 Citizenship US Citizen for clearance purpose Job Description · Contribute substantially to the system architecture design and development of the DB layer · Work with system architects to improve existing OLTP model transaction cost reduction and increase the overall data throughput · Tune SQL queries and database performance for OLTP and DSS applications within the development environment · Participate in design and code reviews documentation of design implementation of methodologies to ensure high quality database implementations · Diagnose and troubleshoot performance problems using MethodR performance analysis methodology · Implement key database instrumentation tool sets · Assist in data modeling processes · Setup and execute database performance benchmarks · Implement database administration and performance best practices · Execute benchmark simulations for critical use cases · Perform database system and SQL profiling activities based on poorly performing use cases · Refactor poorly performing SQL when necessary · Review and tune initialization parameters memory structures and physical data layout for optimal performance · Database design table design data modeling performance tuning · Create and maintain tools that simplify Database Support tasks · Trouble shoot performance issues on application backends databases · Design code and test new features and functionality based on requirements provided · Design software maintenance and bug fix procedures · Assist customers in implementing largescale Oracle Grid clusters using Oracle Real Application Clusters (RAC) Oracle Data Guard Oracle Automatic Storage Management (ASM) and Oracle Grid Control (OEM) · Implement best practice examples for Oracle RAC ASM and Data Guard operational procedures related to o Installation and Configuration o Performance Management including tuning and capacity planning o Backup and Recovery using RMAN o Failover and failback operations o Patching and upgrade activities including rolling upgrades o Cluster expansion through node additions o Cluster management during node evictions and emergency situations o Storage configuration for ASM o Clusterware monitoring and diagnosis procedures Requirements BS or MS in Comp Science or Engineering preferred Customer consultative experience required Proven strong innovative and analytical ability with extensive implementation skills Expert on DBMS kernels with distinguished achievements on database query optimization Proven success in performance optimization for such OLTP and OLAP applications like SAP Peoplesoft Siebel or others Proven track record in building and operating highly scalableperforming24x7 webenabled database applications Must be a team player and have excellent communication skills Attention to detail and a commitment to quality work 68 years of experience as a database administrator andor developer Extensive knowledge of Oracle (PLSQL) Experience working in both OLTP and Data Warehouse environments Enthusiastic interest in mastering monitoring and management software (Quest Hotsos and other database related tools) Experience with two or more versions of Oracle (8i9i10g) on UNIX andor Windows platforms for an enterprise application Experience working with a Product Development team in an agile software development environment Demonstrated proficiency of troubleshooting techniques and detailoriented problem diagnosis Demonstrated proficiency in Oracle JDeveloper Oracle SQL Developer TOAD or equivalent tools Minimum 4 years of experience in database design setup and maintenance product database deployment and operations Qualified candidate must have indepth Oracle experience with installation configuration performance tuning high availability backuprestore and application development for enterprise class systems Demonstrated experience with Oracle Real Application Clusters on Linux Demonstrated experience with Oracle Data Guard preferably in an RAC environment Experience in working with storage and SANs in an ASM environment Experience in using RMAN in a RAC Data Guard environment Experience in using Enterprise Manager Grid Control to manage and monitor database services in a RAC environment Experience in working with very large databases (VLDB) in excess of 1TB Must have a BS in Computer Science or related area of study and be eligible to work in the United States United States Citizenship and the ability to obtain and hold a US Public Trust andor Census clearance Thanks and Regards Sweety Joshi Resource Manager USM httpwwwusmsystemscom business systems inc 14175 Sullyfield Circle Suite 400 Chantilly VA 20151 Ph 7035441998 Cell 4058194070 Fax 7039950830 email sweetyjusmsystemscom mailtosweetyjusmsystemscom wwwusmsystemscom httpwwwusmsystemscom Ranked No10 in the Washington DC areaWashington Business Journal 2010 Smart CEO Award Winner By SMART CEO Magazine Baltimore USAshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshyshy Inc5000 Recognized Fastest growing private company in USA Office Locations Washington DC Atlanta Boston Denver Hyderabad India RMAN, Data guard, OEM, ASM, oracle pl/sql
Dice - 23 months ago - save job - copy to clipboard