| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateEMAIL AVAILABLE Ph:PHONE NUMBER AVAILABLE Proffesional Summmary . 10+ years of IT Experience and 10+ years in Oracle 12c/11g/10g/9i/8i DBA in Production, Development, Test and Data warehousing environment in Oracle and teradata. . Experienced in oracle RAC / ASM environment & Data guard, Database cloning. . Experience 4+ years in My SQL databases. . Experienced in Installing 12C Grid Infrastructure. . Experienced in Managing Oracle Software Library and Database Lifecycle. . Migrated / upgraded database from Oracle Version. . Experinece in compliance management using IAM. . Experience in Backups and Recovery skills that involve logical backups (Import / Export/Data pump), Hot/Cold Backup using RMAN. Planning Backup / Restoration / Recovery Strategy for 24x7 operation support . Applying patches, Database upgrades, Maintaining cluster servers. . Performance and tuning using AWR reports, ADDM, Oracle 10G/11g Advisors. . Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, Tuning Disk Usage etc. . Tuning of SQL statements using tools like Explain plan, TKPROF, Auto trace, STATSPACK , DBMS_PROFILER , Gathering statistic , analyzing tables and indexes. . Experience in Table partitioning and rebuilding, validating the Indexes. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants etc. . Experience in Modifying Storage for tablespaces in Capacity Planning, Space Management,, Storage Allocation, segments, Undo Segments depending on application requirement. . Data loading using Faster Batch Processing, SQL Loader, external tables, UTL_FILE package etc. . Excellent SQL, PL/SQL programming skills like Triggers, Stored Procedures , Functions, Packages. etc in developing applications . Experience in Table partitioning and rebuilding the Indexes. . Worked as a part of team in 24x7 production/development environment and provided on-call and day-to-day support. . Working knowledge of nosql monodb(Took a training from professional to understand the deep concepts and got hand on their lab). . Worked on golden gate for replication. . Set up 12c OEM environment for database monitoring, installed plugin for goldengate. . Experience in UNIX shell script. . Manage databases on Sun Solaris, Linux, Windows-NT, AIX and Windows 2000. . Well versed with all phases of SDLC, quality process and procedures like business requirements definition, enterprise strategy and architecture, guidelines and standards, process/data flow, conceptual / logical/physical/design, performance, partitioning, optimization, scalability / throughput, data quality, exception handling, Metadata, Master Data design , implementation, auditing etc. . Significant experience in Data Modeling , Dimension Modeling, Star Schema, snowflake schema using Erwin tool, DB Artisan, ER Studio, , Power Designer, DB desinger.Education & Certification . Masters in Computer Science (M.Sc.) in 2003, Kurukshetra University, India . ORACLE - 9I (2004), 10G (2007) (DBA-TRACK)Technical Summary|Databases |Oracle- 12c, 11g,10g, 9i, 8i,Teradata - 5, 4.x,Sql Server, MS|| |Access, My SQL ||DBA Tools |OEM (Oracle Enterprise Manager 12C,11G), Golden Gate ,Toad, || |SQL Server Management Studio, DB Artisan, Platinum SQL || |Station & Analyzer, DB Vision, DB Designer, PL/SQL Editor, || |Erwin ||Monitoring Tools |Nagios, MRTG ||Tools |Harvest, VSS, Edit Plus 7, Test Director , Excel, Word, Power|| |point, Visio etc ||Languages |D2k (Forms, Reports),PL/SQL, Visual Basic, C, C++, JAVA ||Job Functions |Handling Database, Analysis, Design, Coding, and Testing || |,Documentation, Maintenance, Application Support, || |Configuration Management, Project Management ||Operating Systems |XP, Win 2000/2003, Solaris 8, Sco- UNIX, Linux, AIX, HP-UX ||Others |Shell Scripting |WORK EXPERIENCECare FirstBlue CrossBlue BlueShield(BCBS)- Owings Mills MDJanuary 2014 to Till DateRole: Oracle Database AdministeratorProject : ODS/EDM Data Resource ManagementEnvironment: Oracle 10g, Oracle 11g, Golden gate,Oracle 12c on Linux/AIX CareFirst makes health care its No.1 priority. The firm is a not-for- profit, non-stock holding company with subsidiaries providing managed health care plans to about 3.3 million members in Maryland and Washington, DC. The company's main subsidiaries, CareFirst of Maryland and Group Hospitalization and Medical Services are licensees of the Blue Cross - more... and Blue Shield Association. Together, the subsidiaries do business as CareFirst BlueCross BlueShield and offer Blue- branded HMO and PPO plans, as well as consumer-driven coverage, to individuals and employers throughout their service areas. Non-Blue subsidiaries and affiliates provide life insurance and third-party benefits administration. In addition to traditional and consumer-driven (high deductible, low premium) plans, the company also provides some Medicare and Medicaid options, and it serves more than 570,000 members in the Federal Employees Health Program. With health care costs continuing to rise, the company has been looking for ways to reduce costs across the board. . Implements and maintains Oracle databases in support of the development and installation of new systems for data warehouse, E- commerce and corporate systems. . Uses available tools and utilities to provide for necessary DBMS maintenance activities: Database reorganizations,backup and recovery, space management, performance and tunning and change management. . Performed mutilple upgrades from 11.2.0.2.0 to 11.2.4.4. . Worked on Compliance management using IAM. . Performed multiple upgrades from 10G to 12C database. . Performs system adminstration and system management functions for Oracle database systems. . Assist application developers and other clients with database usgage and software development activities. . Maintains and installs Oracle database software, Oracle Enterprise Planning (ERP) software, DBA Oracle tools and the coroprate repository software. . Represents DBA on departmental level technology projects and assumes project management responsibilities for enterprise projects. . Set up 12c OEM environment for database monitoring, installed plugin for goldengate. . Golden gate monitoring on veridata. . Applied regularar patched based upon oracle recommendation and security audits. . Trains and counsels less experienced DBA staff members. . Controls and monitors disk space allocation for mulitple databases. . Provide Oracle DBA support and problem resolution support for developers. . Creates,loads and refreshed databases for testing. . Enforces and maintains corporate data and database policies,guidelines and standards. . Updates and maintains corporate data and database dictionary and uses in support of applications development, data warefould and end user support. . Assist application development and operations personnel in the identification and resolution of problems related to supported DBMS platforms. . Creates the Database Lifecycle for differenct environments. . Works on the Templates for the standard configurations. . Provided the 24/7 support in Monitoring, Maintenance and Planning of the database servers and their availability. . Helped out with creating, recommending and defining tools, standards and best practices all over the enterprise. . Works on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc. . Used Oracle analytical functions to reporting purpose . Applied patches, Database upgrades, Maintained cluster servers . Provide recommendations to optimize the queries. . Worked on Day to day DBA acitivities: Creation of new users, assign required privileges, creation of new database instance, provide AWR reports for performance issues etc.Centers for Medicare & Medicaid Services- ColumbiaAugust 2013 to Jan 2014Role: Oracle DBA (CDBA Team)Project : Central DBA TeamEnvironment: Oracle 11g,12C on Linux, SQL Server 2008 SP1 on WindowsServer 2008 R2 The Centers for Medicare & Medicaid Services (CMS) provides direction and technical guidance for the administration of the Federal effort to plan, develop, manage and evaluate health care financing programs and policies. To this end, CMS needs to procure a wide range of supplies and services to support Medicare and Medicaid programs including Research Studies and Demonstrations, Utilization of Health Services, Provider Fraud and Abuse, Health Quality and Standards, Computer Programming, Data Processing, Office Supplies, Computer Hardware and Software etc. . Created Processes and Templates for CMS databases to set Monitoring threshholds. . Created the Process and Work insturctions to add New targets in the monitoring enviroments. . Created the Database Lifecycle for differenct environments. . Worked on the Templates for the standard configurations. . Provided the 24/7 support in Monitoring, Maintenance and Planning of the database servers and their availability. . Helped out with creating, recommending and defining tools, standards and best practices all over the enterprise. . Designed Process flow and created templates for each and every service used and provided. . Installation and upgrade SQL Server software and services. . Helped the Client in creating deploying a stable development domain. . Worked on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc. . Used Oracle analytical functions to reporting purpose. . Worked on Compliance management using IAM. . Applied patches, Database upgrades, Maintained cluster servers . Provide recommendations to optimize the queries. . Worked on Day to day DBA acitivities: Creation of new users, assign required privileges, creation of new database instance, provide AWR reports for performance issues etc.Shire Pharmacutical, Chesterbrook - PASeptember 2012 to August 2013Role: Database ArchitectureEnvironment: Oracle 11g,12C on Linux, SQL Server 2008 SP1 on WindowsServer 2008 R2, My SQL on LinuxProject : Datababse-Re-Architecture Shire is one of the world's leading specialty biopharmaceuticalcompanies. In practice Shire focuses on developing treatments forconditions where the impact of its drugs can make an immediate and tangibledifference for patients. This might be a therapy to treat an extremely rareand life-threatening disease like Hunter Syndrome or Fabry Disease; or amedicine for a specialist condition like ADHD or ulcerative colitis; or atreatment to help the healing of diabetic foot ulcers which if not treatedeffectively, can dramatically affect the lives of the patient and theirwhole family.Responsibilities: . Planning Database Re-Architecture. . Discovered the Re-Achitecture requirements. . Designed and Develped Re-Achitecture requirements. . Installed of 12C Grid Infrastructure on Linux 5.8 with 2 Nodes of OMR and OMS . . Intalled SQL Server 2008 SP1 on Windows server 2008 R2. . Installed My SQL on Linux. . Installed Oracle 11g Grid Infrastructure on Test and Dev environments. . Installed SQL server Pluggins to add SQL database in the 12C monitoring environment. . Created Backup & Recovery Processes including process diagrams for Oracle and SQL databases. . Create Backup & Recovery Templates for Oracle and SQL databases. . Worked on Compliance management using IAM. . Created Processes and Templates for to set Monitoring threshholds. . Created the Process and Work insturctions to add New targets in the monitoring enviroments. . Created the Database Lifecycle for differenct environments. . Worked on the Templates for the standard configurations. . Provided the 24/7 support in Monitoring, Maintenance and Planning of the database servers and their availability. . Helped out with creating, recommending and defining tools, standards and best practices all over the enterprise. . Planned and Implemented High Availability and Disaster Recovery solutions. . Designing and Planning on implementing Virtualization to reduce IT cost and increase productivity. . Designed Process flow and created templates for each and every service used and provided. . Installation and upgrade SQL Server software and services. . Created documentation for My SQL and SQL server databases. . Helped the Client in creating deploying a stable development domain. . Worked on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc. . Used Oracle analytical functions to reporting purpose . Applied patches, Database upgrades, Maintained cluster serversFedex Corporation , Memphis - TNSep 2011 to August 2012Role : DBA/Developer/ArchitectEnvironment: Oracle 11g,10g on LinuxProject : Roads databases ROADS is a comprehensive route planning, evaluation and execution system for DGO. There are algorithms written by ORSA to calculate the best routes for couriers to drive based on current stop and address information. The algorithms sizing and processing was Initially performed by capacity planning with the assistance of the solutions center.Responsibilities: . Worked as production DBA in 11g RAC and ASM environment. . Worked on My SQL databases. . Applied patches, Database upgrades, Maintained cluster servers . Worked on Golden Gate replication. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc.. . Worked on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN. . Worked on Git for version control. . Used Oracle analytical functions to reporting purpose . Installation of oracle 11g on Unix , window environment . Created databases for development, test and Refreshed the database from Prod to test and Dev . Performance and tuning using AWR reports, ADDM, 10G Advisors. . Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, Tuning Disk Usage etc. . Data loading using Faster Batch Processing, UTL_FILE package etc. . Implemented and Setup Data Guard. . Shell scripting, Automation of the system using cron tab. . Created and maintained stored procedure, function, trigger, and packages etc. . Tuning of SQL statements using tools like Explain plan, TKPROF,Auto trace, STATSPACK , DBMS_PROFILER , Gathering statistic , analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints. . Experience in Table partitioning and rebuilding, validating the IndexesFedex Corporation , Memphis - TNMay 2010 to Aug 2011Role : DBA/Developer/ArchitectEnvironment: Oracle 11g,10g on LinuxProject : Revenue data profilingFedex Revenue data comes from different databses and consolidatie insingle database. The purpose of this project is to maintain productiondatabsae.Responsibilities: . Worked as production DBA in 11g RAC and ASM environment. . Applied patches, Database upgrades, Maintaed cluster servers. . Worked on My SQL databases for security and capacity planning. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc.. . Worked on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN , Datapump and SQL Obacktrack. . Created the database desing as per businedss requirment for their new testing environment in using teradata. . Used Oracle analytical functions to reporting purpose . Manage the multiple database environments using grid control. . Installation of oracle 11g on Unix , window environment . Created databases for development, test and Refreshed the database from Prod to test and Dev . Performance and tuning using AWR reports, ADDM, 10G Advisors. . Worked on Git for version control. . Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, Tuning Disk Usage etc. . Data loading using Faster Batch Processing, UTL_FILE package etc. . Implemented and Setup Data Guard. . Shell scripting, Automation of the system using cron tab. . Created and maintained stored procedure, function, trigger, and packages etc. . Tuning of SQL statements using tools like Explain plan, TKPROF,Auto trace, STATSPACK , DBMS_PROFILER , Gathering statistic , analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints. . Experience in Table partitioning and rebuilding, validating the IndexesFirst Data Corporation , Hagers Town - MDJun 2009 to May2010Role : DBA/DeveloperEnvironment: Oracle 11g,10g on HP-UX,LinuxProject: TMS systemFirst Data Corporation is a worldwide leader in electronic paymentsolutions. First Data through its bank partners gives a competitive edge tobusinesses and financial institutions, offering a complete portfolio ofpayment systems and services to meet the globally expanding needs of ourclientsResponsibilities: . Worked as production dataware house DBA in 10g RAC and ASM environment. . Implemented and Setup Data Guard. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants, tablespace management and capacity planning etc.. . Installation of Oracle -10g on HP-UX . Worked on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN,datapump and SQL Obacktract utility. . Created databases for development, test and Refreshed the database from Prod to test and Dev . Performance and tuning using AWR reports, ADDM, 10G Advisors. . Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, Tuning Disk Usage etc. . Worked on Git for version control. . Tuning of SQL statements using tools like Explain plan, TKPROF,Auto trace, STATSPACK , DBMS_PROFILER , Gathering statistic , analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints. . Experience in Table partitioning and rebuilding, validating the Indexes. . Applied patches, Database upgrades, Maintaed cluster servers . Data loading using Faster Batch Processing, UTL_FILE package etc. . Shell scripting, Automation of the system using cron tab. . Mangage the multiple database environment using grid contrl. . Created and maintained stored procedure, function, trigger, and packages etc. . Provide technical assistance to Oracle developers . Data modeling , Database Designing , Preparation of ReportsFedex Corporation , Memphis- TNNov, 2008-to Jun 2009Role : Sr Oracle DBA/DeveloperEnvironment: Oracle 10g on HP-UXProject: imarketThe proposed Marketing tool will be a single global solution for FedEx(across OpCos, regions and channels) to plan, design, execute, and fulfillmarketing campaigns. In addition, the tool will also be a centralrepository for storing marketing collateral/documents and all marketinginteractions.Responsibilities: . Implemented and Setup of Data Guard. . Performed database administration like User Management and implement Security using Roles, Privileges, Grants . Applied patches, Database upgrades, Maintained cluster servers . Worked on ASM. . Worked as production DBA in 10g RAC ,ASM environment. . Tablespace management and capacity planning . . Installation of Oracle -10g on HP-UX . Worked on Backups and Recovery policy that involve logical backups (Import / Export), Hot/Cold Backup using RMAN,datapump and SQL Obaktrack utility. . Created databases for development, test and Refreshed the database . Performance and tuning using AWR reports, ADDM, 10G Advisors. . Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, Tuning Disk Usage etc. . Worked on the grid control system to manage the multiple database environment. . Experience in Table partitioning and rebuilding, validating the Indexes. . Data loading using SQL Loader,external tables,UTL_FILE package etc. . Shell scripting, Automation of the system using cron tab. . Created and maintained stored procedure, function, trigger, and packages etc. . Migrate the databases from old Servers to New Servers. . Capacity planning for the new requirements. . Help to optimize the queries, Tuning of SQL statements using tools like Explain plan, TKPROF,Auto trace, STATSPACK , DBMS_PROFILER , Gathering statistic , analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints. . Work on the all the Helpdesk Tickets related to OracleLafarge North America, Inc , Herndon - VASep 2008 to Nov 2008Role : Sr oracle DBAEnvironment: Oracle 10g on HP-UXProject: Lafarge databaseLafarge in North America is the largest diversified supplier ofconstruction materials in the U.S. and Canada. We produce and sell cement,ready-mixed concrete, gypsum wallboard, aggregates, asphalt, and relatedproducts and services. Our products are used in residential, commercial andpublic works construction projects across North America.Responsibilities . Up gradation and Installation of Oracle -10g, RAC Applied patches. . To provide solution for data warehousing and to design system architecture . Created databases for development, test, production etc. . Performance and tuning using AWR reports, ADDM, 10G Advisors. . Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, Tuning Disk Usage etc. . Tuning of SQL statements using tools like Explain plan, TKPROF,Auto trace, STATSPACK , DBMS_PROFILER , Gathering statistic , analyzing tables and indexes, using Pipeline function, parallel query, Inline views, analytical function, Bulk Binds, Bulk Collect, Query rewrite, hints. . Experience in Table partitioning and rebuilding, validating the Indexes. . Data loading using Faster Batch Processing, UTL_FILE package etc. . Change database character set . Applied patches, Database upgrades, Maintaining cluster servers. . Worked with ETL team for extraction , transformation and load BODI IX (ETL tool) . Created summary tables; materialize views for query rewrite purpose etc. . Create partitioned table , index according to the need of application . logical backups (Import / Export), Hot/Cold Backup (RMAN) . Shell scripting, Automation of the system . User Management and implement Security using Roles, Privileges, Grants . Implementation and Setup of Data Guard. . Data modelling , Database Designing , Preparation of ReportsPortfolio Recovery Associates , Norfolk - VAJan, 08 - Aug 2008Role : Sr oracle DBAEnvironment: Oracle 10g on HP-UXProject: PRA DatabasePortfolio Recovery Associates, Inc. "PRA" and its subsidiaries purchase andmanage portfolios of defaulted and bankrupt consumer receivables andprovide a broad range of accounts receivable management services tolenders, service providers, governments, and others.Responsibilities: . Up gradation from 9i to 10G. . Maintain the performance of the Application and the database. . Implemented the grid control 10G. . Managing the Grid control. . Monitoring the tablespaces and adding the data files as per the requirements. . Refreshing the database from Prod to test and Dev using Hot Backup . Cloning through RMAN. . Documentation for the existing tasks. . Maintain the performance of the Application and the database. . Database operations like Analyze tables, indexes, rebuilding of indexes . Taking the Backups using RMAN, Imp/Exp methods.IBM - Airtel , IndiaMay, 2007-Dec, 2007Role : Sr oracle DBA/Developer/Application DBAEnvironment: Oracle 10g on HP-UXProject : Airtel Call-Home DatabaseAirtel Limited provides end-to-end telecom solutions to corporate customersand national & international long distance services to carriers. Objectiveof this project is to provide the Online Support for the Applications PACSto ensure the Best performance of the database of Complete Airtel BillingSystem.Responsibilities: . Installation of oracle 9i on sun solaris . Monitor and manage database operations, . Backup and recovery strategy for the database using exp/imp , RMAN, Standby database etc. . Shell scripting related to oracle . Creating and maintaining stored procedure, function, trigger, packages etc. . Database operation to suit the applications like indexes, constraints etc. . User Management and implement Security using Roles, Privileges, Grants and Enroll users on request. . Tablespace management and capacity planning for optimal performance. Evaluate and resize space usage on daily bases. . Using Export/ Import RMAN for backup and recovery of the database. Using Sql * Loader tools for data transfer and migration.ING , Atlanta, GA & Hartford, CTOCT 2005 to NOV 2006Role : Sr oracle DBA, MSSQL server DBAEnvironment: Oracle 10g on HP-UXProject: Database of INGING Group is a global financial services company of Dutch origin with 150years of experience, providing a wide array of banking, insurance and assetmanagement services in over 50 countries. Approximately 113,000 employeeswork daily to satisfy a broad customer base: individuals, families, smallbusinesses, large corporations, institutions and governments. Based onmarket capitalization, ING is one of the 20 largest financial institutionsworldwide and ranked in the top-10 in Europe. The Objective of this projectis to handle the database Production, Test, Development of US ING Remotelyand managing the database on approximately 200 different servers.Responsibilities: . Moving the data from Production, test and development database server. . To check the performance issues at application level and database level. . Capacity Planning, Space Management . Database Upgrades/Migration . Creating and maintaining stored procedure, function, trigger, and packages etc. . Database operation to suit the applications like indexes, constraints etc. . To optimize the queries to enhance the performance of the database. . User Management and implement Security using Roles, Privileges, Grants . Tablespace management and capacity planning for optimal performance. . Export/ Import for backup and recovery of the database. . Using Sql * Loader tools for data transfer and migration. . User Management and Implement Security using roles, Privileges . Backup and Restoration of database. . Import and export . Shell scripting in unixEmployer: Chandigarh Infotech Center Ltd.Client :- Modern Steels LtdOctober 2002 to October 2005Role : Sr oracle DBAEnvironment: Oracle 10g on HP-UXProject: Modern steel databaseObjective of this Project to maintain the production database of ModernSteel. Job involved maintaining the production database of Accounts Dept,administration dept, production of complete steel engineer plant having 60nodes. About 3000 tones of steel production are done and of all stages ofdata are recorded.Responsibilities: . Installation of MySQL and Oracle -10g . logical backups (Import / Export), RMAN . To check the performance issue at application level and database level in Oracle. . Created and Maintained stored procedure, function, trigger, packages, jobs . Database operation to suit the applications like indexes, constraints etc . Table space management and capacity planning for optimal performance. Evaluate and resize space usage on daily basis. . Shell scripting, Automation of the system . Create summary tables, materialize views for query rewrite purpose etc. . Create partitioned table, index according to the need of application. . Worked on data guard |
