OBJECTIVE:

A position that will recognize, nurture and leverage from my skills and make a significant contribution to 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
• 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 to a successful implementation of .centric project on schedule at Confidential 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 Confidential .
• 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 Confidential .

TECHNICAL IT EXPERTISE:

RDBMS: Oracle 8i, 9i, 10g,11g, 12c, DB2 UDB 7, 8 and 9SQL 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: Visio, Microsoft Office.

Version Control Tools: Clear Case, Visual Source Safe.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• 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 also 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

Confidential

Principle Analyst

Responsibilities:

• Supporting 80 different clients ranging from 100GB to 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 to 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.

Confidential

Sr. Database Administrator

Responsibilities:

• 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 to 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 to 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 to be compliant to Confidential policies and procedures for Monitoring and Tuning. Also used SQL Loader for loading data.
• Configure and setup Pro-Active monitoring scripts in crontab for backup, and space management.
• Have Performed migration from Oracle 9i on Windows server to Oracle 10G LINUX
• Involved in migration from 32 bit Oracle 10.1.0.5.0 on Red Hat LINUX to 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 to 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.

Confidential

Sr. IT Analyst/Database Administrator

Responsibilities:

• Leading a team towards a successful implementation of Crystal reports and Business Intelligence project into production for generating and sending those reports to the clients as telecom billing system.
• Supported RAC system for High Availability for Confidential and RX3000 Pharmacy Databases.
• 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 to 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
• HP ProLiant DL380G5 on a 16GB DDR2 Memory with Hot Plug storage on HP NC360NC Gigabit Adapter and Fiber channel Controller.
• 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
• Installed Oracle 10.2.0.1 RAC software and patched it to upgrade to 10.2.0.4
• Involved in creating the database with ASM on BLOCK devices and with separate installation for ASM and database respectively.
• Configured Recovery Manager (RMAN) for RAC Database backup, restore and recovery operation with Legato Networker.
• Configured the listeners and aliases to set up Transparent Application Failover (TAF).
• Setup ADDM AWR/Statspack packages in various databases as the tool for database performance monitoring.
• Involved in writing both SQL scripts for Monitoring and Tuning
• Backup and Recovery of the RAC databases including design of Backup & Recovery strategies using Legato Networker 7.4 and Legato Networker 7.2
• Resolving performance issues involving disk I/O, CPU usage, hanging issues for OLTP applications.
• Database Programming using PL/SQL, Responsible for writing database Triggers and Stored Procedures.
• Monitoring SQL Server databases which are used for internal projects running on java.
• 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

Oracle Database Architect

Responsibilities:

• Led the team to a successful implementation of .centric project into production with complete Software development life cycle on Schedule.
• Worked with various departments and externals clients related to Confidential for access to inventory databases specific to 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 Confidential .
• 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 to 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 to 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 to 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 to 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 to 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

Team Leader

Responsibilities:

• 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 to automate the backup utility and monitored the database.
• Worked with developers with database issues and assisted in SQL tuning and table creation, updating the data dictionary changes.
• Setup Stats pack package in various databases as the tool for database performance monitoring.
• Created Standby Databases which makes it available for developers all the time.
• 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 to 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 to Oracle Application Server which was used as middle tier for connectivity to the database.
• Developed shell scripts for batch processing and database transactions
• Written the procedure which will create the triggers dynamically to 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 to System Events through Triggers.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTL FILE.

Confidential

Database Administrator

Responsibilities:

• Developed, completed, and evaluated UNIX based System Test Plans, along with recommendations to the current databases.
• Developed and evaluated database implementation test plans along with recommendations to current database systems.
• Created and maintained all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Performance tuning of SQL Queries and Validating SQL Queries.
• Installing Databases on Unix and Windows Based Operating system
• Scheduled Backup and Recovery of the databases.
• Created backup strategies for new databases.
• Stored procedures, database triggers and unit testing.
• Utilities such as EXP, IMP, SQL*Loader, datapump, OEM and RMAN.
• Resolved many performance issues involving disk I/O, CPU usage, SQL tuning.
• Database Programming using PL/SQL., Responsible for writing database Triggers and Stored Procedures.
• Wrote shell and perl scripts for automation.
• Managing control files and redo log files in different partitions to 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 Confidential Shops.
• Involved in writing both shell & Perl scripts and Data Analysis, Data Base Implementation and Support, Data Base Monitoring and Tuning

Confidential

Database Administrator

Responsibilities:

• 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.
• Automated the backup utility and monitored the database and RAC instances.
• 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
• Auditing the database using FGA (Fine Grain Auditing) for error messages or to 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 to Oracle Application Server which was used as middle tier for connectivity to the database which had a build in Custom Single Sign On application with Java.
• Used Oracle FARM to monitor application servers.
• Monitored database that uses Power Builder Applications.
• Maintenance and monitor RAC Nodes and instances that uses OCFS on Linux Operating system.