SUMMARY:

• Highly educated adept professional with over 20 years of extensive experience in diverse IT areas - Software Development Life Cycle (requirement analysis, design, development, testing, and implementation), Data Flow Analysis & Designing, Database Designing (logical & Physical), Building & Administration, Data Warehouse process flow analysis and development.
• Experience in IT Professional management, Project Management, Database/Hardware Capacity Planning, Database and SQL query performance tuning, Backup/Recovery, Application Support, User & Security Administration, setting up of the Development, QA and Production environments
• Strong problem solving, business analysis, interpersonal skills combined with excellent written and oral communication skills
• Working knowledge of HTML, CSS, Java, JSP, JavaScript, PHP, Visual C#, ASM, RAC, Toad
• Avid learner, result and detail oriented team player adept at exceeding deadlines in fast paced environments

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g, 9i/8i, SQL Server 2008, 2005, MySQL, Ingres

Languages: C, SQL, PL/SQL, Unix/Linux shell scripting, Visual C#, Java, JSP, JavaScript, HTML, CSS, PHP

Oracle utilities: RMAN, Exp/Imp, Data Pump, SQL*Loader, SQL*Plus, Explain plan, SQL Trace, Statspack, AWR/ADDM, SQL Developer, tkprof, RAC, Oracle Gateway DG4ODBC, Oracle Grid Control 12c, ASM, oakcli

Oracle Engineered System: ODA (Oracle Database Appliance)

Operating Systems: UNIX (HP, Solaris, AIX, Ultrix), Linux, and Windows, VMS

Version Control: Subversion, Visual Source Safe (VSS), SCCS (Source code control system), CMS (Code Management System)

Miscellaneous Tools: JDeveloper, Apache Server, ftp, sftp, Agile/Scrum, Excel, Access, Word, Commvault, Control-M, Service One, Service Now, ODBC, JDBC, Toad, Erwin

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator

Confidential, Alpharetta, GA

Responsibilities:

• Majority of work is done on ODAs (Oracle Database Appliance) in a RAC environment, using Oracle releases 11g and 12c. The work involves:
• Creation of new databases using “oakcli” command utility. The database types created are CDB (Container database) and Non-CDB
• Create and test RMAN scripts for CDB/PDB backups via Commvault
• Register / Manage databases in Oracle 12c OEM
• Perform Quarterly ODA patches (involving Infrastructure, Storage, database Homes). It involves pre-patch work, creation and obtaining approval of Change Requests in Service Now
• Research, review and create documentation on new features of Oracle 12c, especially, Interval Partitioning, Unified Auditing. Developing & test the new features, and make recommendations to application/database team for including them in future standards.
• Active participation in diverse project meetings to gather database specific requirements, build Oracle databases (including Standbys), Backup setup using RMAN, Update/Maintain database documents governing DBA activities and project specific details, as per project requirements
• Developing/modifying Unix shell and SQL scripts to streamline Database administration processes

Sr. Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Meeting with database clientele to gather requirements for new projects, enhancements to existing database(s), and providing pertinent solutions
• Routine DBA duties like database/SQL performance monitoring and tuning, Development/QA database refreshes from Production, verification of successful database backups and taking corrective actions, as required, maintaining adequate space for database objects to ensure threshold compliance, hence, ensuring performance
• Update/Maintain database documents governing DBA activities and project specific details, as deemed necessary
• Ensuring timely resolution to end user issues, viz., creating new users with appropriate access to the database(s) or specific database objects, connectivity to the database(s).
• Loading project specific metadata to database(s) as per client’s request
• Developing/modifying Unix shell and SQL scripts to streamline Database administration processes

Database Architect

Confidential, Norcross, GA

Responsibilities:

• Active participation in brain storming sessions with business users to gather database requirements, analyzing them and developing solutions.
• Create/Maintain Policies & Procedures for Oracle database development and administration. Creating detailed documentation for diverse projects
• Design, develop and implement PL/SQL routines, SQL and UNIX shell scripts to automate DBA tasks as well as implement business rules for different projects. Created and maintained Cron jobs to execute shell scripts.
• Analyze projects requirement and plan database and hardware capacity for optimal performance of the existing and new Oracle databases
• Create and manage Oracle database objects, viz. tables, database links, packages, triggers, etc.
• Setup database auditing; maintain SOX security compliance in Oracle databases. Generate database access and privileges report pertaining to various schemas and remediate the vulnerabilities
• Refresh/clone development /QA databases using OS copy using NFS mounts, export/import, data pump and RMAN Duplicate database utilities.
• Implement required database changes to production by following defined Change Management guidelines defined by the company. This includes creation of Production change requests in Service One and Service now.
• Troubleshoot and resolve database and SQL query performance bottlenecks using Perfstats, AWR, Explain plans, SQL Tracing and tkprof
• Install, upgrading Oracle database software on UNIX and Windows Servers. Install MySQL on Linux servers, create and support MySQL databases
• Oracle client installations & configurations on Wintel servers, ODBC setup including Oracle Gateway DG4ODBC to connect Oracle databases to MS SQL Server databases
• Install and configure SQL Server databases on Wintel platforms.
• Configure log shipping and ensure standby servers in sync. Backup/Restore of SQL server databases, security setup and maintenance
• Install Oracle Grid Infrastructure, RAC database software and create RAC databases using ASM following Oracle guidelines
• Monitor Oracle databases in Production and development environments using Grid Control.
• Educate SQL server DBAs on Oracle database design and administration aspects, UNIX shell scripting, PL/SQL programming, etc.

Database Manager

Confidential, Atlanta, GA

Responsibilities:

• Managed a team of IT professionals. Responsibilities included meeting with clients to gather project requirements, planning resources including timelines, organizing and delegating assignments, evaluate development work, ensuring timely delivery of projects as well as exceeding the expected quality. Provided weekly progress updates to the division director
• Developed Standard Operating Procedures for database administration as well as software development ensuring compliance with company policies. Managed user privileges, and applications source code in Subversion
• Analyzed database and query performances using Statspack, explain plan utilities. Implemented remedial measures to boost performance successfully
• Successfully designed and developed ETL processes between Informix and MySQL databases to fulfill On-Air and website business requirements
• Designed and created logical as well as physical databases (Oracle, MySQL). Responsible for Oracle server installations and database upgrades. Created, implemented and maintained RMAN scripts for database backups and recovery.
• Created Visual C# scripts to extract data from RSS Feeds for publishing on company’s website and TV broadcasting
• Developed Modules for the Membership Database Application at Confidential, using PL/SQL packages, object types and collections - hence, savings thousands of dollars as the work was not contracted out
• Successfully designed, developed and implemented an events calendar module for the Georgia Council of Arts website -- the system was developed using Java Server Pages (JSP), JDeveloper tool and Oracle database. Created detailed documentation for the end user on system usage. Trained end users on application usage.
• Clone the MySQL databases
• Run ETL processes for data migration from Informix to MySQL.
• Monitor system disk space and perform automatic cleanup.
• Managed user privileges, and applications source code in Subversion
• Developed Confidential ’s website modules using PHP and Java Scripts

Sr. Software Engineer

Confidential, Atlanta, GA

Responsibilities:

• Created logical database models using Erwin and created physical databases
• Installed and upgraded, Oracle databases on UNIX and Windows
• Created PL/SQL procedures for a Sales Force Automation application.