SUMMARY

Education- Bachelor of Science Technical Management

Certifications-Oracle certified associates (OCA
Certifications: Oracle Certified Associates (OCA)

Systems: UNIX, Windows, Windows 2000, Mac OS, Linux, UNIX Solaris, Mainframe
Databases: Oracle9i, Oracle10g, DB2, SQL Server, Sybase, DB2
Languages: SQL, HTML
Software: MSOffice, Lotus Notes, Netezza, Quest Toad.

Work Experience

Confidential,Sql/Oracle DBA(contracter) June2012-Current

• Ensure Oracle database systems operate efficiently and securely..
• Worked DBA in strict SLA environment.
• Managed databases, from planning and testing stages through implementation and support.
• Understanding of security and backup procedures to ensure database integrity.
• Performed DBA in Windows/Unix environment
• Maintained Sybase database/Replication servers.
• Experience in UNIX scripting/Cron scheduling.
• Basic SQL Server 2008 Administration.
• Certified in Oracle
• Ability and willingness to learn new technology and acclimatize to any work culture
• Major activities performed are installation, configurations, creations, patching, migrations, upgrades, audits, backups, disaster recoveries, performance tuning, storage structures, documentation, startup/shutdown, high availability, troubleshooting, system analysis, schema objects, database design, physical disk storage, users accounts and security, Sysadmin Jobs, change control management and documentation on Windows, UNIX & Linux platforms.
• Very good knowledge of Networking concepts and client/server architecture
• Excellent commitment and have experience working as an individual and in a team
• Troubleshooting Discoverer and custom reports issues and monitoring the performance.
• Performing database and application health checks
• Monitoring disk space of flash recovery area and archive log file system.
• Handling issues related to CPU Sessions, Locks & Invalid Objects, and Tablespace/file system space Alerts.
• Knowledge of Data Modeling concept.

Confidential,Oracle/Sybase DBA Dec11 –May2012

• Maintain Oracle/Sybase Databases handling daily activities.
• Worked on incident tickets including problem isolation, analysis, root cause, and solution
• Standard database operations, daily checks using OEM,GRID,unix scripts
• Performed DB-Mods (Database modifications) which includes running SQL,PL-SQL scripts ,refresh environment using exp/imp,expdp/impdp.
• Worked on Physical/logical Standby databases (issues like delayed log application, stop-start of log apply).
• Worked on Sybase databases common tasks were doing Db-Mods(running isql scripts, resolving issues(1105,log/db segments issues, user lock/unlock, error log checks for issues)
• Worked on Sybase replication server (checking heartbeat, data differences, starting dataserver/replication server etc all using scripts).
• Monitored/resolved backups issues ( rman scripts running through autosys).
• Worked with big Autosys environment (non-prod and prod)from where all jobs are run (backups,system health check,customer jobs plus many other jobs) ,resolved issues with jobs by checking details/logs and working with Autosys team.
• Worked in Day and night shifts
• Understanding of RAC systems.
• Summary of daily works plus skills applied in this project are:-
• Oracle issues like ORA errors like undo 1555,600 etc checking alert log, starting stopping databases, checking/killing process/sessions ,adjusting database parmeters,modifying tnsnames.ora and pushing to environment(full push or partial),unlocking/locking users, assigning roles/privileges,monitor space and add space to tablespaces,hadling user issues like client installation issues/local tns/odbc/connectissues,oracle installation/patching, rerunning failed rman backups, running archive backups manually in case of issues where it is filling up due to heavy activity ,many times changed archive destination on the fly to point archives to other location to avoid archive-stuck situation.
• Sybase issues like log segment/data segment issues/db-mods/error log check,user lock/unlock,dataserver/replication server issues, start and stop rep server, heartbeat check

Confidential, (DBA)-Columbia, MO Sept 10- August 11

• Applied schema changes, database software patches and upgrades
• Installing, creating, managing Oracle Database Software.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Maintenance and monitoring of different clients databases (table spaces, data file, control files)
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, creation of users, schemas, table spaces and other database object.
• Performance tuning including analyzing expensive SQL from app side
• Rebuilt Indexes/tables/adjusted indexes for better performance of SQL
• Performing Database Backups and recovery.
• Hot and cold backup
• Granting Roles and Permissions to SQL Server Users so as UNIX users
• Installation of client tools on user machines and establishing connectivity to databases.
• Manage Oracle database administration assignments for diverse industry clients.
• Used SQL and PL/SQL: scripts, triggers, procedures, and packages to automate the projects.
• Troubleshoot and diagnostic activities
• Experience with the full project lifecycle from conception to implementation and support
• Deep understanding of RDBMS structures and how they interact: tables, indices, triggers, procedures, etc

Confidential,DBA- Kansas City, Mo May 08-Sept 10

• Support the SQL application and database administration
• Monitoring the database growth and maintenance of the same
• Loaded the data from the legacy system into a few oracle application modules
• Used SQL and PL/SQL: scripts, triggers, procedures, and packages to automate the projects
• Supporting 24x7 production systems
• Installing SQL Server and oracle on Windows and Linux.
• Granting Roles and Permissions to SQL Server Users so as UNIX users
• Working on daily DBA tasks through Maximo tickets.
• Standby/Failover Administration
• Worked on Applications upgrades as needed.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Applied schema changes, database software patches and upgrades
• Logical and physical database design for various new development releases and implementation of new customers
• Kept company intranet with help desk ticket and order tracking
• Implemented load balanced web servers for high availability
• Established standards for SQL installations and maintenance