SUMMARY

• 15 Years of total IT experience as database administration, Leading Projects and building large public domain databases.
• Working experience with large databases up to 30 TB, data migration, against other databases such as SQL Server.
• Proficient in working with Dev, SIT, UAT, LaST, ProdFix and Data Warehousing environments.
• Installation, configuration, monitoring, creation, upgrades Oracle database (8i/9i/10g/11g) using OS via. Sun Solaris, SCO - Unix and Windows XP/NT servers.
• Experience with database backup, restore, and disaster recovery using RMAN.
• Hands on experience of Imports/Export, log-miner, TTS, SQL *Loader, External Tables and Standby databases.
• Strong knowledge of Oracle 10g and 11g RAC database with ASM.Experienced with Veritas cluster ware
• Used Tkprof, statspack, AWR/ADDM/ASH etc for application and database tuning.
• Performed database Masking using custom and OEM scripts.
• Performed data replication through Golden Gate.
• Proficient in writing scripts in UNIX based environments for managing the user's roles, privileges, monitoring the database, Disk space management, Cold backup and Hot backup. Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts.
• Manages data security and application standards in databases.
• Configure SSH to capture data from remote database and scheduling the operation using Unix crontab.
• Wrote utility to downsize Production database for Development usage.
• Create and maintain Logical structure of database using ErWin.
• Proficient in identifying and maintaining Table/Index Partitioning by reorganizing object structure for tuning purpose.
• Tune queries using Hints, Execution Plans which are consume more resources as shown in statspack/Awr reports.
• Experienced in configuring multi-master Streams to propagate changes to other servers.
• Analyzed & Fine-tuned the SQL Server/ORACLE performance at regular intervals.
• Strong knowledge of Oracle data-dictionary, configuration of Oracle Enterprise Manager (OEM) tools for monitoring, performance enhancement and debugging using other tools such as Precise I3, OEM etc.
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Managed team, assigned them the targets, addressing any issues of concern regarding performance of team members, monitoring performance, coach, counsel and develop people competencies with in the team etc.
• True team player; maintain client/customer relationships by providing timely, superior quality products and services; understanding of client/customer needs opportunities and satisfaction criteria.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL Server

Languages: Shell Programming, AWK Programming, Developer 2000, Visual Basic, Java, Shell Script, SQL, PL/SQL, HTML, C

Operating Systems: UNIX (Sun Solaris) / SCO, Windows 2007/2003/2000, Server/ XP /NT 4.0

Tools: OEM, SQL*Plus, SQL*Loader, RMAN, Toad, LogMiner, AWR/ADDM, TKPROF, JDBC, ODBC, vi editor, VNC viewer, Veritas, Toad, Sql and PL Developer

Other: Flash, MS-Office, Adobe-Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, CA

Sr. DBA

Environment: Oracle 11g, Sql-Server 2012, .Net, IDERA Sql Safe, Data Masking, ErWin

Responsibilities:

• Analyze Application and business impact before upgrading database to 11g.
• Change flow management
• Refreshing development databases from Prod.
• Performing custom masking on PII information
• Performance analysis on DB servers on regular basis.

Confidential, Austin, TX

Lead DBA Team

Environment: Oracle Server 9i/10g/11g RAC, Linux, Sun Solaris, OEM, SQL-Developer, SQL*Plus, Toad, Windows 2007/Vista, SAN, VERITAS, AWK Programming, RMAN, ErWin, AWR/ADDM/ASH Reports, Round Robin DB, JAVA, Grid Control, Data Guard, Data Pump, Precise I3, TimesTen database, Golden Gate, Database Masking.

Responsibilities:

• Analyze Application and business impact before upgrading database to 11g.
• Upgrade Oracle 10g to 11g databases and resolved issues caused by 11g behavior.
• Configuring, administering and monitoring RAC databases such as Local, Dev, Sit, Aging, LaST and Production databases for developer and Production support.
• Capacity Planning for OLTP database and generates different graphs to show data file growth, temp file growth, data growth and case growth etc
• Creating, splitting and merging Table partitions to support archival and retention policies as per business need.
• Configure, installed and performed data Replication using Golden Gate.
• Converted whole schema with 1700 tables from Range-Partitioned to Ref-Partitioning.
• Performed Data masking using OEM and Custom Scripts to hide original data from Developers.
• Participating the DB change meeting for new requests, maintaining database and application standards, propagation of data through change management etc.
• Check and apply data security permissions across all environments to different users.
• Creating and maintaining logical Database structure using Erwin Utility. Tables and Columns definition are maintained in separate database as per defined architecture.
• Fine Tuning the Sql for both OLTP/OLAP and ad-hoc queries and assists developers to rewrite SQL queries in better way.
• Rebuild tables and indexes for highly fragmented tables/indexes in OLTP env.
• Performed purge/archival activity for very large tables from OLTP database to secondary database. ETL includes impdb/expdb, Transportable Tablespaces techniques etc.
• Using Sql Loader, external tables utility to load data from external files that contained many table’s data in one single file.
• Downsize Production databases to Development database by copying subset of integrity data using Sql and Pl/Sql technique.
• Creating, maintaining and refreshing small Size environment.
• Wrote Unix script to copy a case based data from one environment to another to replicate issues for debugging purpose.
• Participated in moving Data Center/Production server from San Anglo to Austin Texas.
• Monitoring and creating Tablespace, DB files and Temp files whenever required. Wrote cronjob to send an alert whenever tablespace reaches its space threashold.
• Maintaining Business Standards, minimum configuration of objects etc for OLTP environment and send out the mail if any environment is not meeting the requirements.
• Administering and Maintaining database objects such as Tables, Views, Synonyms, Materialized views, LOBs, database links etc.
• Using AWR/ADDM/ASH etc reports to find and check Database Instance health check and session status. Precise I3 is used to present graphical representation of wait events, top query behavior between time frames.
• Wrote shell Unix scripts and AWK programming to maintain Production server such as batch comparison report, hourly response time of production, change management for data consistency, security access during each release, database and application standards etc.
• Configuring SSH to get remote call to capture SAR information related to CPU and IO etc and saved in Oracle Database table. Automation is done through cronjob.
• Grant and Revoke permission to user. Setting user resource limit on Logical standby servers in order to avoid excessive resource consumption by one session.
• Tracking session activity, object definition, generation of insert statement, generation of explain plan, checking of user grant permission, setting up scheduling job(from client machine) action are used by Toad, Sql-Developer and Sql-Plus.
• Configuration Database tuning and SGA parameter for better performance.
• Administering Physical Standby server for user access.
• Analyze and rectify system troubleshooting from alert log, listener log and trace files as generated by background processes.
• Taking routine backups using RMAN/data pump of full size and small size environments.
• Opening TAR with Oracle if some issue is not solved by our own. Ie materialized views sometime not get refreshed etc.
• Using LogMiner to debug and find important information such as original values, transaction information etc from Redo Log files for Auditing and debugging purpose.
• Providing 24*7 ongoing maintenance and support. ie if there are blocking locks occur, some batch job hung during Batch Window or not responding for long time etc.

Confidential, Columbus, OH

Sr. Oracle DBA

Environment: Oracle Server 9i/10g/11g, Linux, OEM, Precise I3, SQL-Developer, SQL*Plus, Sun Solaris, AIX Unix, Toad, Windows 2003, Veritas, People Soft, ASM, AWK programming, RMAN, Oracle Gateway, Toad, ErWin, Advance Queue, Streams, AWR Reports.

Responsibilities:

• Configuring, administering and monitoring Oracle databases.
• Plans, Leads, Install and Upgrade Oracle 9i to 10g for production servers.
• Maintain database security accesses at database and object level by writing Shell and Awk Programming.
• Reorganize tables and Tablespaces for very large tables by using bigfile talespaces.
• Monitor Security, grants, permission and space level issue using Toad/Sql-Developer.
• Open TAR with oracle to solve some issue.
• Tune some initialization parameter to avoid some critical errors such as snapshot too old error, timeout errors.
• Clone PeopleSoft database and created many databases for testing such as SIT, LaST.
• Configured Oracle Gateway to access net services.
• Reorganize tables by using Partitioning feature of Oracle.
• Using ErWin to maintain database structure.
• Recovered tablespaces using Transportable Tablespaces.
• Defined Fine Grained Access Control using Oracle Policies.
• Co-ordinate meeting to implement tasks assigned and lead others whenever required.
• Wrote shell and AWK scripts to export whole database in many parts using Data Pump, so that they can export all tables parallel to reduce export time.
• Separate very large tables from export so that can export separately.
• Wrote customized ftp script so that during refresh, DBA has to do least affords.
• Created user interface using shell Script in AIX platform to refresh very large database (VLDB). It also captures errors during import, such as lack of space in tablespace or in table.
• Performed Sql and stored procedure tuning using Explain plan utility and advisors.
• Using ADDM, AWR, ASH, Precise I3 to chech Database performance and instance health check.
• Configure Multi-Master Replication.
• Configure and maintain Data Guard as standby server.
• Configuration oracle networking using sqlnet and tnsnames files.
• Configure Oracle Streams to replicate portion of data using LRC capture technique from redo log files.
• Implement LogMiner to overcome user errors also configure Standby logical and physical databases.
• Interact with People-Soft team to resolve issues.
• Configure External tables and direct load script to load data from flat files into Database.
• Configure SSH and Crontabs for automation scripts.
• Using Toad and Sql-developer to perform DBA related work, such as tracking of session, object level permission and definition etc.
• Used flashback technology for flashback drop, query and table.
• Performed database backups using RMAN and stored in TSM.
• Performed Database Hot/Cold Backup of Oracle Database on TSM Server.
• Logical backup using multiple streams using Data Guard on Unix - Solaris-64bit
• Partition the table for better performance, used Hints for optimizer (CBO) to guide the execution plan of the query.
• Perform Capacity planning while refreshing new database.
• Created objects using OS files using Oracle SQLLOADER.
• Downsize the database by exporting subset of integrity data.
• Rewrite SQL and PL/SQL queries and helps Developers writing efficient scripts.
• Involving in detecting and correcting the inconsistence of reports.
• Applying patches as required.
• Analyze and rectify system troubleshooting from alert log and trace files as generated by background processes.
• Applied row level security using VPD Fine-Grained Access.
• Involved in creation of Database links. Used Data Pump to export database links only
• Configuring and taking Hot and logical Backup using Crontab schedulers.
• Participated in Database Development Cycle for RAC 10g.
• Added disks and diskgroups to ASM in RAC Database.
• Checked and maintained the status of RAC with srvctl utility.

Confidential

Database Administrator

Environment: Oracle 9i, PL/SQL, SQL *Trace, .Net, Windows 2003 Server, Toad, Sql-Developer, Sql-Loader, Log-Miner, ErWin, VB, OEM, RMAN

Responsibilities:

• Creating the Database and maintaining its nomenclature.
• Downsize the database for developers by deleting records.
• Creating the tables and maintaining its integration.
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Perform general technical trouble shooting and give consultation to development teams
• Interacting with Team Leader and Programmers.
• Writing Mail and other Schedulers.
• Establish and maintain sound backup and recovery policies and procedures
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Used ADDM, AWR, ASH reports, and wrote batch scripts.
• Debug Redo Logs using Log-Miner to capture original values etc.
• Loaded data from CD-ROM to Production database on regular basis.
• Performed regular RMAN backups.

Confidential

Sr. Programmer

Environment: Oracle Server 10g, OEM (Oracle Enterprise Manager), SQL-Server, SQL*Plus, PL/SQL, Sun Solaris, AIX Unix, Windows2000/XP, Veritas, SAP, ASM, Netbackup, .Net technology, Toad, SANS storage, RMAN, Oracle Gateway, AWR Reports, ErWin.

Responsibilities:

• Initiate some initialization parameters required to upgrade and tune the oracle database.
• Install and Upgrade oracle 9i version to 10g Real Application Cluster (RAC).
• Configure and Install Oracle Cluster Ready Service Software.
• Checked and Installed RPM Packages for Oracle 10g RAC.
• Created many databases for Testing and Refreshing.
• Efficient in tuning Sql-queries and stored procedure for performance issue using advisors.
• Prepared all prerequisite on Solaris machine to install Oracle 10g RAC.
• Network configuration of RAC environment.
• Start and stop the cluster
• Managed Crontab schedules to manage backups and database monitoring.
• Created External tables using SQLLoader
• Configure TNS and Listener files for net services
• Implement LogM0069ner to overcome user errors also configure Standby logical and physical databases.
• Define Logical/Physical data modeling of new database using ErWin.
• Manages disk and diskgroup using asmcmd command.
• Monitoring Database performance using Automatic Database Diagnostic Monitor.
• Created ASSM tablespace for better performance.
• Worked in administering multi-node RAC databases using Grid Control.
• Worked for Optimization, Security and Storage Management.
• Configured Oracle Stream to transfer data from Corporate office to Head Office.
• Create and maintain ASM Disk group.
• Analyzing Database performance using ADDM/AWR in RAC environment.
• Configure External tables and direct load script to load data from flat files into Database.
• Partition the table for best performance.
• Downsize the database to store latest data for query purpose.
• Performed Capacity Planning of database using OEM.
• Tune Sql queries by watching Explain Plan command.
• Used flashback technology for flashback drop, query and table.
• Performed Database Hot Backup/Cold Backup of Oracle Database on Tape Devices and Logical backup using multiple streams using Data Pump on Unix - Solaris-64bit
• Designed and developed scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Partition the table for better performance or use Hints for optimizer (CBO) to guide the execution plan of the query.
• Written RMAN scripts used to take backups.
• Involved in capacity planning and allocation of space for production database.
• Recover Block level corruption using RMAN new feature.
• Written UNIX shell scripts to take backups and transfer it to another machine using ftp.
• Involving in detecting and correcting the inconsistence of reports.
• Maintaining the Distributed Databases.
• Applying patches as required.
• Creating and maintaining the stored procedure/ table level function and other objects required for .Net Application of Sales Module.
• Involve in removing the inconsistence while processing the cumulative record and compare with incremental reports.
• Analyze and rectify system troubleshooting from alert log and trace files as generated by background processes.
• Maintain database security accesses at database and object level
• Configure Data guard for high availability.

Confidential

System Administrator

Environment: Oracle 8i/9i, PL/SQL, SQL *Trace, Developer 2000, Sun Solaris, HP Unix, SQL-Server 2000, Erwin, OEM, Visual Basic 6.0, ODBC, Standby Server, DBartisan, Perl, RMAN, Primavera Application, Oracle Gateway.

Responsibilities:

• Configuring and Monitoring Production databases.
• Plan, Implement and test disaster recovery system, using RMAN/shell scripts.
• Design and implement of database backup strategy and performed full incremental and Cumulative backup using RMAN.
• Created and maintained Standby servers.
• Created new database for testing and pre-refresh testing.
• Upgrade oracle database from 8i to 9i using import export and catupgrd.sql.
• Troubleshooting with RMAN backup problem.
• By rewriting SQL queries, creating the indexes and change the execution plan, able to improve the performance by 80 %.
• Configure Oracle Parameters to tune Oracle Instance.
• Wrote shell scripts to perform DBA work, LogMiner to analyze redo log files.
• Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Created External tables using SqlLoader and DataPump utilities.
• Scheduled backups and other maintenance utilities using Unix cron scheduler.
• Maintained Cluster ware for RAC environment.
• Provide 24/7 monitoring of network and database operations to ensure top operating efficiency.
• Involved in performing Capacity Planning.
• Maintenance of Physical Data guard server and logical standby server.
• Involving in analysis and designing the objects for many modules such as Purchase, Store, Production Planning, Sales, Finance and Hr Pay for the ERP software.
• Used ERwin tools for data Modeling.
• Configure Oracle Stream to replicate database object in another server to solve some performance issue.
• Configure Statspack/tkprof utility to rectify performance related problems.
• Creating and performing integration check on the objects if required.
• Wrote and modify stored procedure, functions, triggers and packages.
• Supported Production and Development databases.
• Supported and coordinated with developers for removing the logical errors in the application.
• Tuning the Sql-code inside the stored procedures, applications, functions etc using SQLTUNE packages.
• Supporting Production database (Oracle and DB2) 24*7.

Confidential

Sr. Programmer

Environment: HP Unix, Sun Solaris and Windows 2000/XP, Oracle 8i/9i, Developer 2000, Oracle Gateway, RMAN, OEM, Flash, Java, TomCat, JDBC, Java Beans, Sql-Server, Toad, Visual Basic.

Responsibilities:

• Provide database administration on production, testing and development database.
• Estimate Storage requirement Database Objects.
• Configure TNS and Listeners for Oracle Gateway.
• Involved in life cycle development of ERP package, which was developed in Developer 2000 for Poddar Tyres Ltd.
• Designed and maintenance of Sql-Server Database and its objects such as Tables, views, procedure and Function.
• Involved in backup and recovery of Sql-Server and Oracle Databases.
• Involved in finding the blocking transaction in SQL-Server and Oracle database and took appropriate actions.
• Conduct the meetings of developers with higher authority to implement the projects.
• Developed many interfaces for Finance, Sales modules using Oracle Form 6i, Java, Visual Basic etc.
• Generated many reports related to Trial balance, sales Finance etc using Oracle Reports.
• Created database links between two servers using Oracle database link feature.
• Configure RMAN to take backup of many databases.
• Recovered database/tablespaces using RMAN utility and other techniques.
• Involved in Tuning Sql Queries for Oracle Database.
• Configured Tomcat software to provide its Http services.
• Prepare backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Develop/customize UNIX shell scripts to automate routine DBA tasks of taking backups, exports and monitoring space availability and database performance database. Developed Standards for the developers.
• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.
• Wrote stored procedures in Oracle for many modules used in project.
• Creation of users, roles and maintain system security.
• Apart from Database activities, I have developed a multimedia CD called ‘The Sikh Encyclopedia’ using Flash MX software, which was launched in London, UK.
• Created an attractive design for the website ‘sachems.org’ using flash-MX.
• Developed an application for Golden Temple Named “SGPC Parshad Billing System” using Java, JDBC/ODBC as front end with Sql-Server as backend, which allow user to enter the sale of Karah Parshad. If there is connection breakage, then program starts saving the data locally.