Objective:

• A position that will recognize, nurture and leverage from my skills and make a significant
• contribution t the growth of the company using my project management skills.

Profile Summary:

• Around 12 years of IT experience, over 2 years of experience in Java skills and
• Around 8 years' experience with database administration, Architectural and Leadership roles. My experience includes working on latest technologies such as Oracle Cloud, Java,
• SQL Server 2005 and 2008, Oracle Application Server, WLS, SOA, Goldengate.
• Led a team t a successful implementation of .centric project on schedule at PennDOT managing more than 25 people.
• Conducted project meetings and make sure of the cost control and expenses. Prepare budget and estimated the schedule and cost of the project. Responsible for the quality control, cost cutting, and requirements of the budget and project. Review basic architectures of the projects and specifications at PennDOT.
• Interacted with Clients and met committed target dates with quality deliverables.
• Took Ownership and Follow-up on Root Cause Analysis RCA's .
• Arranges regular meetings including daily, weekly and monthly for reviews.
• Service Delivery review with upper management.
• Directed planning and documented standards for best practices and quality assurance.
• Responsible for Deliverables/work products such as RDBMS oracle database , ETL Informatica and Crystal Reports.
• Revised Cost and Risk Management Plan at PennDOT.

Hardware:

Maintenance of the PC as a hobby with in Depth Knowledge of the working of a computer system, with assembly of a system and trouble shooting of operating systems.

Seminars/Training:

• Oracle Internal Training on Oracle Exadata Machines.
• Oracle Internal Training on SQL Tuning
• Oracle Internal Training on SOA Service Oriented Archicture .
• Oracle Internal training on WLS Weblogic Server .
• Oracle 9i Database Administration, Professional Oracle Corporation certification Training.
• DB2 UDB V8.1 Database Administration.
• Green Belt Training Program on 6 Sigma
• SAP for Basis
• ADM 100 Web AS Administration I
• ADM 102 Web AS Administration II
• BS 315 Work Load Analysis

Technical IT Expertise:

• RDBMS Oracle 8i , 9i, 10g,11g, 12c, DB2 UDB 7, 8 and 9,
• SQL Server 2000 and 2005.
• Operating Systems UNIX Systems Sun Solaris, AIX, Linux and HP/UX and
• Windows Operating System Administration.
• ERP SAP, People Soft, Oracle Applications
• Cloud Computing Cloud, Python, Infrastructure, Big Data, Hadoop, PaaS
• Project Management Tools Visi, Microsoft Office.
• Version Control Tools Clear Case, Visual Source Safe.

Professional Experience

Oracle Confidential

Role and Responsibilities:

• Working as Principle Consultant mentoring junior dba's, took initiatives on new projects writing scripts, APEX and reviewing changes, Cloud Infrastructure, Cloud PaaS and SaaS Support.
• Supporting 80 different clients running on RACONE Node and RAC.
• Build a Standby Databases for a 8 node RAC for high availability.
• Work with the application team on performance issues.
• Cloning and refreshing database for create testing database
• Applying patches and upgrades of the Oracle databases, including Standby and patches includes BP4, BP11, BP14, BP17.
• Supporting different Oracle different databases and als using Oracle Enterprise Manager Cloud Control 12c running on top of WLS.
• Wrote Applications which sits on oracle cloud using APEX involving, PLSQL, and TRIGGERS etc.

Tools: Exadata Full Rack x2-8, Oracle Cloud, APEX, WLS, 12c EMCC, WLS, SOA, RAC, RACONE Node, Standby Database, Oracle Database Appliance ODA ,Python, Cloud Computing, PaaS. Exadata Full Rack x4, Weblogic 12c,mCollective, Hadoop,

IT Convergence, Confidential

Role and Responsibilities:

• Working as Managing Principle Analyst mentoring junior dba's, took initiatives on new projects writing scripts and reviewing changes.
• Supporting 80 different clients ranging from 100GB t 4TB size of databases.
  • Running with 32 CPUs on Linux Operating on Optic Fiber with 100GB Memory.
• Build a logical Standby Databases for a 4 node RAC for high availability.
• Support RAC databases with 6 nodes with a size of 3Tb in size.
• Build a logical Standby Databases for a 4 node RAC for high availability.
• Work with the application team on performance issues.
• Cloning and refreshing database for create testing database
• Applying patches and upgrades of the Oracle databases, including Standby and Streams databases.
• Migrate the database from one server t other server.
• Supporting Oracle Applications 11i and R12 databases.

Tools: Veritas Netback up, TOAD, Supporting Oracle Applications with 9i, 10g and 11gR2 databases, Sun Solaris, HP-UX, Redhat Linux, 6 Node Real Application Clusters RAC on 11gR2 and on 10gR2.

Telstra Corporation, Confidential

Role and Responsibilities:

• Worked as Sr. Database Administrator mentoring junior dba's, took initiatives on new projects writing scripts and reviewing changes.
• Support of 15 Node Business Critical RAC database with a size of 50TB.
• Running with 64 CPUs 64 on sparcv9 processor SUNW,SPARC-Enterprise-T5220 SunOS 5.10. 32GB Memory
• Supported 3000 Database Ranging from 30GB t 50TB, Where 800 databases was RAC databases while 400 where standby databases dataguard and 200 databases were oracle streams,
• Build a logical Standby Databases for a 4 node RAC for high availability.
• Running with 48 CPUs The sparcv9 processor SUNW,Sun-Fire-15000 SunOS 5.9 9.2.0.6 with 16GB Memory.
• Working closely with application team to ensure to adhere to the policies and procedures pertaining to the database
• Implemented backup/restore procedures in ARCHIVELOG mode by using RMAN
• Database performance/Statement tuning, Table sizing, and administration.
• Was responsible for Performance tuning of databases .
• Applying patches and upgrades of the Oracle databases, including Standby and Streams databases.
• Cloning and refreshing database for create testing database
• Was responsible for Oracle APEX configuration, setup and support.
• Migrate the database from one server t other server.
• Setup, Support of Standby Databases using dataguard for stand alone, Multiple node RAC databases.
• Setup and monitor standby database for an active to active node on HP-UX 1000 Mhz PA-RISC 64-bit 9000/800/rp3440 1 architecture on HP 11.23
• Worked on APEX Central Databases and generated pages for maintaining an internal Website for Database Team.
• Wrote shell and SQL scripts for databases t be compliant t Telstra policies and procedures for Monitoring and Tuning. Als used SQL Loader for loading data.
• Have Performed migration from Oracle 9i on Windows server to Oracle 10G LINUX
• Configure and setup Pro-Active monitoring scripts in crontab for backup,and space management.
• Involved in migration from 32 bit Oracle 10.1.0.5.0 on Red Hat LINUX t 64 bit Oracle 10.2.0.4.0 on SUSE LINUX.
• Installation of GRID Agent and monitoring the status of agents for monitoring through GRID.
• Regularly perform health checks of the database for all production databases
• Managed a mission critical Oracle 8i database on Veritas with active -passive setup
• Have handled character set Conversion of database from UTF8 t AL32UTF8 for SIEBEL application, Usage of Utilities such as EXP, IMP, datapump and RMAN for data refresh.
• Setup ADDM AWR/Statspack packages in various databases as the tool for database performance monitoring.

Tools: BMC Remedy Tool V7, Oracle APEX 10g, 11gR2 Database, Sun Solaris, HP-UX, Redhat Linux, 4 Node Real Application Clusters RAC on 11gR2, 15 Node RAC, Veritas Netbackup, Tivoli, SQL Back Track.

Sacramento County Office of Information Technology

SAC Sacrament County of Information Technology is a county government that is responsible for various services t public within the Sacrament County in California, USA. OCIT Office of Communications and Information Technology a group within the Sacrament County that handles both central information technology and telecommunications services.

Role and Responsibilities:

• Supported RAC system for High Availability for CHS and RX3000 Pharmacy Databases.
• Leading a team towards a successful implementation of Crystal reports and Business Intelligence project int production for generating and sending those reports t the clients as telecom billing system.
• As a Sr. IT Analyst/Database Administrator which involves Design and recommendations.
• Interact with clients and departments in identifying needs and requirements. Review, Establish and document methods and process.
• Installed Oracle Grid Control System version 10.2.0.4 for support and easy maintenance of oracle database systems, setting up alerts and Notifications. Used Oracle Grid Control effectively for Performance tuning scenarios.
• Setup Database Audit of Databases for AUDIT and restrict access for external access.

• Performed Conversion of Single Node t RAC database instances and vice versa.
• Installation of GRID Agent and monitoring the status of agents for monitoring through GRID.
• Applied advisory patches, security patches and performed patchset upgrades on the databases.
• Support and Maintenance of 4 Node Real Application Cluster RAC Database 10.2.0.4 on Block Devices and RAW partitions for OCR and voting Disks and using ASMLib on block devices running on Red Hat Enterprise Linux AS release 4 and build Two node DR
• Configured the listeners and aliases t set up Transparent Application Failover TAF .
• Configured Recovery Manager RMAN for RAC Database backup, restore and recovery operation with Legat Networker.
• Involved in creating the database with ASM on BLOCK devices and with separate installation for ASM and database respectively.
• Installed Oracle 10.2.0.1 RAC software and patched it to upgrade to 10.2.0.4
• Installed Red Hat Enterprise Linux AS release 4 on both the nodes after creating necessary partitions using fdisk utility and configured different parameters for setting up private network, public network, rlogin, rsh, etc on 2 Nodes
• HP ProLiant DL380G5 on a 16GB DDR2 Memory with Hot Plug storage on HP NC360NC Gigabit Adapter and Fiber channel Controller.
• Monitoring SQL Server databases which are used for internal projects running on java.
• Database Programming using PL/SQL, Responsible for writing database Triggers and Stored Procedures.
• Resolving performance issues involving disk I/O, CPU usage, hanging issues for OLTP applications.
• Backup and Recovery of the RAC databases including design of Backup Recovery strategies using Legato Networker 7.4 and Legato Networker 7.2
• Involved in writing both SQL scripts for Monitoring and Tuning
• Setup ADDM AWR/Statspack packages in various databases as the tool for database performance monitoring.
• Setup of Active to active Streams between 10.2.0.4 and 9.2.0.8 for data replication and monitor Queues
• Developed a custom application for Property Database using oracle application express.

Confidential

Role and Responsibilities:

• As an Oracle Database Architect for a development project which involves integrating and converting all the legacy systems t latest technologies using Java, Web Sphere and Oracle based systems. Lead the team t a successful implementation of .centric project. The main responsibility of the role has been t provide ongoing database performance and architecture support t the .centric team. This has been accomplished through:
• Led the team t a successful implementation of .centric project int production with complete Software development life cycle on Schedule.
• Worked with various departments and externals clients related t PENNDOT for access t inventory databases specific t Pennsylvania Department of Motor Vehicles.
• Conducted project meetings and make sure of the cost control and expenses. Prepare budget and estimated the schedule and cost of the project. Responsible for the quality control, cost cutting, and requirements of the budget and project. Review basic architectures of the projects and specifications at PennDOT.
• Interacted with Clients and met committed target dates with quality deliverables.
• Designed, developed and implemented several processes for Department of motor vehicles that served as best practices using oracle's OFA.
• Made sure the SQL was within the accepted SLA's.
• Communicated information t stakeholders on a weekly basis as and when needed with project status and initiatives.
• Responsible for user administration, repository administration and deployment of various applications t UAT Production environment of Informatica.
• Performing backups and deployments of informatica DEV, UAT and PROD applications on server and client side.
• Responsible for user administration, repository administration and deployment of various applications t UAT Production environment of Informatica.
• Performing backups and deployments of informatica DEV, UAT and PROD applications on server and client side.
• Work with developers and change management team t ensure smooth life cycle progress from development through testing and production implementation.
• Responsible for Deliverables such as Oracle Database, ETL Informatica and Crystal Reports
• Review hardware and software requirements and recommend appropriate upgrades and system enhancements.
• SQL tuning analysis leveraging existing tools such as SQL Tuning Advisor, SQL Access Advisor, explain plans, etc
• Analyzed all business functionality and developed technical specifications.
• SQL Tuning and providing recommendations for current database system.
• Created AWR and ADDM tools to monitor the performance of instances on RAC systems
• Involved in writing RMAN scripts for Database backup and Support, Database Monitoring and Tuning
• Created backup strategies for new databases.
• Conversation and migration from legacy data in Mainframes t Oracle.
• Setup and installation of RAC using ASM on version 10g using ASM for evaluation.
• Setup and installation of Oracle version 11g for evaluation.
• Performance tuning of SQL Queries and Validating SQL Queries.
• Created Materialized Views and its log for certain specific queries.
• ADDM/AWR tools for performance tuning running on ZVM based Linux.

Confidential

Role and Responsibilities:

Team Leader: Managing and Helping Developers for SQL Queries and performance of SQL Queries which involves a large database. Applying and uploading the EAR files int oracle application server.

• Coordinating and motivating team members
• Database installation and applying patches on the databases.
• Performed backup and recovery.
• Writing PL/SQL procedures, triggers and functions which were called inside the java program.
• Wrote scripts t automate the backup utility and monitored the database.
• Created Standby Databases which makes it available for developers all the time.
• Setup Stats pack package in various databases as the tool for database performance monitoring.
• Worked with developers with database issues and assisted in SQL tuning and table creation, updating the data dictionary changes.
• Involved in writing both shell Perl scripts and Data Analysis, Data Base Implementation and Support, Data Base Monitoring and Tuning
• Writing PL/SQL procedures, triggers and functions which were called inside the java program.
• Auditing the database using FGA Fine Grain Auditing for error messages or t track the different tables that were being used for performance tuning which were received during the execution of Java programs.
• Installation and Uploading the EAR files t Oracle Application Server which was used as middle tier for connectivity t the database.
• Developed shell scripts for batch processing and database transactions
• Written the procedure which will create the triggers dynamically t audit the particular object based on the user selection.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, Responding t System Events through Triggers.
• Generated SQL and PL/SQL scripts t install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Used PL/SQL programming t develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTL FILE.

Confidential

Role and Responsibilities:

• Wrote shell and perl scripts for automation.
• Database Programming using PL/SQL., Responsible for writing database Triggers and Stored Procedures.
• Resolved many performance issues involving disk I/O, CPU usage, SQL tuning.
• Utilities such as EXP, IMP, SQL Loader, datapump, OEM and RMAN.
• Stored procedures, database triggers and unit testing.
• Created backup strategies for new databases.
• Scheduled Backup and Recovery of the databases.
• Installing Databases on Unix and Windows Based Operating system
• Performance tuning of SQL Queries and Validating SQL Queries.
• Created and maintained all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Database Administrator: Signing off on newly created databases that were migrated from Sun Solaris t AIX. Performing and Monitoring SQL Performance, Created standby database and was als responsible for writing Scripts.
• Developed, completed, and evaluated UNIX based System Test Plans, along with recommendations t the current databases.
• Developed and evaluated database implementation test plans along with recommendations t current database systems.
• Managing control files and red log files in different partitions t reduce the risk of oracle crashes.
• Applied patches, security patches and performed upgrades on the databases.
• Setup ADDM AWR//Statspack packages in various databases as the tool for database performance monitoring.
• Created Standby Databases using data guard for Work brain Application which is used for Employee check In/Out at the GAP Shops.
• Involved in writing both shell Perl scripts and Data Analysis, Data Base Implementation and Support, Data Base Monitoring and Tuning

Confidential

Role and Responsibilities:

• Database Administrator: Managing and Helping Developers for SQL Queries and performance of RAC Instances which involves a large database. Applying and uploading the EAR files int oracle application server. Created a new test box for applications server from the scratch. Responsible for performance and tuning of RAC Nodes, Applying patches.
• Created a new test box for application server from scratch on a VMWare Machine.
• Applied patches, security patches and performed upgrades on the databases.
• Scheduled backups of Oracle RAC Instances and recovery.
• Created a backup strategy for the current systems which involved backing up database, applications servers, Configuration files and operating system files.
• Created AWR and ADDM tools to monitor the performance of instances on RAC systems
• Automated the backup utility and monitored the database and RAC instances.
• Involved in writing RMAN scripts for Database backup and Support, Database Monitoring and Tuning
• Auditing the database using FGA Fine Grain Auditing for error messages or t track the different tables that were being used for performance tuning which were received during the execution of Java programs.
• Deploying and Uploading the EAR and war files t Oracle Application Server which was used as middle tier for connectivity t the database which had a build in Custom Single Sign On application with Java.
• Used Oracle FARM t monitor application servers.
• Monitored database that uses Power Builder Applications.
• Maintenance and monitor RAC Nodes and instances that uses OCFS on Linux Operating system.

Bombardier Aerospace System

Confidential

Roles and Responsibilities:

• Supported multiple production and development databases running on SUN SPARC E4500, E3500 hardware.
• Supporting the Database, which runs on SAP for backup, recovery, performance tuning,and writing new Scripts.
• Client Interfacing with Customers/Business users
• Regular database performance gathering and analysis by deploying Stats pack and regularly collecting stats using STATS and als using hints/parameters as applicable.
• Backup and recovery of the databases including design of backup recovery strategies using Veritas.
• Develop deploy Unix Shell Scripts to automate database backups, performance monitoring, database status reporting, user connections monitoring, database emergency alert notifications thro' emails/pager, etc. automate the scripts thro' Crontab
• Space Management issues of the Production databases including Temporary table space Rollback segment sizing and contention issues.
• Installation and Support of RAC Systems.
• Utilities such as EXP, IMP, SQL Loader, OEM and RMAN.
• Implementing Standby databases, Partitioning of tables indexes, etc. Created E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams using Erwin 4.1