TECHNICAL SKILLS:

RDBMS: Oracle12c/11g/10g/9i/8i/7, MS SQL 2014/2012/2008 R2, IBM PDA / Netezza, PostgreSQL, DB2, MySQL, MongoDB, Sybase

Development Tools: TOAD, SQL*plus, T - SQL,PL/SQL, SQL Developer, Oracle Forms and Reports, Visual Basic, PowerBuilder and Shell Scripting, Eclipse, CVS/SVN, Cygwin

DBA Tools: Oracle Enterprise Manager/Grid Control/Cloud Control, TOAD, RMAN, Exp/Imp, Expdp/Impdp, ADDM, AWR, STATSPACK, SQL Trace/TKPROF, SQL*Loader, DBArtisan, SQL*DBA, Server Manager, DTS/SSIS, ER/Studio, Informatica PowerCenter, ODBC/JDBC

Web Tools: PHP, HTML, DHTML, ASP, FrontPage 98, Image Composer and other tools

Computer Languages: MF/RM/MS COBOL, Pro*C, C/C++, Clipper, VB

Networking: Configuring and Installing Active Networking Components Routers, Switches, and Modems in LAN and WAN

Operating System: IBM AIX, Solaris, RHEL, SUSE Linux, SCO and NCR Unix, Novell 3.x and 4.x, All versions of MS Windows Server/Client, VAX/VMS, VME on ICL, OS/2 Warp

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Environment: Oracle Databases 11g,2/10g/9i, SQL Server 2000-200 8, MySQL, DB2, Netezza, IBM AIX, RHEL, SuSE Linux, TOAD, SQL, PL/SQL, Shell & Perl Scripts, CommVault, Symantec NetBackup, Quest LiteSpeed, NetApp, JIRA, ServiceNow

Responsibilities:

• Performed the additional responsibility as Team Lead of DBAs and contractors for over 8 months
• To Install/Upgrade/Patch, configure, manage and maintain multiple Oracle and SQL Server databases for Development, QA, Pre-Prod and Production environments with database size ranges from 100s GBs to 13 TB
• Provide day to day and 24X7 rotational on-call support for all database environments
• Work closely with Enterprise Planning team, Windows Admin team, Storage, Network and Security team in order to get server infrastructures built to efficiently fulfill applications and databases requirements.
• Verify conformance to Data Centre standards in application systems prior to production implementation.
• Proactively monitor database user access, alert/error logs and physical capacity.
• Providing data migration, transformation, backup & recovery, end-to-end performance tuning and other services to support multi-terabyte sized database environments (OLPT’s and CDW’s)
• Develop, Test, Implement and Manage efficient & effective backup and recovery strategies.
• Co-ordinate and provide day to day support to application developers, QA, user groups, Operations personnel and Application Vendors’ technical teams.
• Evaluate and make recommendations on purchase of software products
• Perform upgrades, patches, replication, data refreshes, performance tuning, and monitoring of Oracle and SQL Server DB environments
• Perform tasks such as user provisioning, access and grants
• Perform corrective actions by responding to each change management request according to its priority and severity level
• Implement and configure data replication using Materialized Views, IBM CDC, Datastage
• Provide technical administration and migration support for non-production Oracle and SQL Server DB environments
• Develop and maintain DB documentation and admin procedures
• Mentor junior team members

Confidential

Sr. Database Administrator

Environment: Oracle Database 8i/9i/10g/11g, Oracle E-Business Suites 11i (worked on upgrading to R12 on test system) PostgreSQL, MySQL, SQL Server 2005/2008, Solaris, RHELinux, TOAD, OEM/GC, SQL, PL/SQL, Shell & Perl Scripts, PuTTY, WinSCP, WebLogic, Legato Networker.

Responsibilities:

• Responsible for day to day as well as 24X7 rotational on-call support mainly Oracle database server Dev, Test and Production environments on Solaris, RHEL and AIX. Also responsible for managing and supporting PostgreSQL, MS SQL and MySQL environments
• Managing all enterprise database backup and recovery using expdp/impdb, export/import, RMAN, hot/cold backup depending on system environment and requirement.
• Managing standby database with/without DataGuard
• Providing database technical support for all scheduled enterprise maintenance windows.
• Perform deployments for upgrades, maintenance and enhancements
• Install and maintain STATSPAK, collect and purge SP data and prepare reports
• Creating, moving and copying databases among environment servers
• Managing/monitoring usage of disk space, memory and connections using Names Servers.
• Fine tuning the Oracle server to achieve optimum performance using ADDM, AWR and OEM/ Grid Control.
• Creating and maintaining batch jobs for backups and house keeping procedures using cronjobs
• Creating pre-approved user accounts, grant privileges and roles on multiple databases.
• Analyzing and trouble-shooting various day-to-day problems and Oracle network administration.
• Tablespace creation and allocating space to the created tablespaces as required
• Troubleshooting and supporting databases using SQL & PL/SQL, OEM/GC and TOAD.
• Testing and deploying stored procedures, functions, packages, and triggers and referential integrity constraints to achieve efficient performance.

Confidential

Sr. Oracle DBA

Environment: Oracle database 8i/9i/10g, MS SQL 2000, Solaris, Red Hat Linux, IBM AIX, Windows 2000 & 2003, TOAD, OEM, PL/SQL, Shell & Perl Scripts, SecureCRT, TeamTrack, SiteScope, ClearCase Tools, Informatica, Veritas Indepth for Oracle, Flux Job scheduler, WinSCP, WebLogic, NetApp Storage

Responsibilities:

• Responsible for day to day as well as 24X7 rotational on-call support Dev, Test and Production environments on Solaris, RHEL and AIX
• Worked as an active member of IG DBA team for upgrading databases from 8i and 9i and 10g with RHL 3 to 4. Shell and Perl scripts created and used during this process.
• Managing all enterprise database backup and recovery using export/import and RMAN.
• Providing database technical support during all scheduled enterprise maintenance windows.
• Managing Oracle and MS-SQL database data files & log files
• Perform deployments for App/Web upgrades, maintenance and enhancements
• Install and maintain STATSPAK, collect and purge SP data and prepare reports
• Creating, moving and copying databases among environment servers
• Managing/monitoring usage of disk space, memory and connections.
• Fine tuning the Oracle server to achieve optimum performance using ADDM, AWR and OEM.
• Creating and maintaining batch jobs for backups and house keeping procedures using cronjobs
• Creating pre-approved user accounts, grant privileges and roles on multiple databases.
• Analyzing and trouble-shooting various day-to-day problems and Oracle network administration.
• Table space creation and allocating space to the created table spaces as required
• Troubleshooting and supporting databases using OEM/RAC and TOAD.
• Testing and deploying stored procedures, functions, packages, and triggers and referential integrity constraints to achieve efficient performance.
• Writing shell scripts in ksh and bash to automate database management and data delivery work
• Data migration between Oracle, SQL Server, MS Access and Sybase databases utilizing Oracle stored procedures, shell scripts, ETL, SQL*Loader, Informatica and DTS

Confidential

Commercial Bank International Programmer/DBA

Environment: Oracle database 9i/10g, Solaris, NCR Unix, RM Cobol, Windows 2000, Oracle Applications 11i HRMS and ICF Brokerage System. C++, SQL server 2000 used for Direct/Indirect facilities application system.

Responsibilities:

• Managing/monitoring usage of disk space, memory and connections.
• Fine tuning the Oracle server to achieve optimum performance using ADDM, AWR.
• Database backup and recovery using export and import utilities and RMAN.
• Creating and maintaining batch jobs for backups and house keeping procedures.
• Granting roles and permissions to users on multiple databases.
• Analyzing and trouble-shooting various day-to-day problems and Oracle network administration.
• Tablespace creation and allocating space to the created tablespaces as required
• Troubleshooting and supporting multiple databases and instances using RAC.
• SQL and PL/SQL programming to create stored procedures, functions, packages, and triggers and referential integrity constraints to reduce the network traffic and achieve efficient performance.
• Writing Unix shell scripts to automate database management and data delivery work
• Creating reports for monthly average balances on the basis of daily balance for direct/indirect accounts.
• Data migration/integration between Cobol, Oracle, SQL Server, MS Access and Sybase databases utilizing Oracle stored procedures, C++, Pro*C, shell scripts, SQL*Loader, Informatica and DTS

Confidential

Oracle DBA/Analyst Programmer

Responsibilities:

• Installation, upgrades & configuration of Oracle server software and related products
• Data modeling, Data analysis and normalization
• Taking care of database design, implementation and troubleshooting
• Developing database queries, stored procedures and other database objects using PL/SQL
• Installing and maintaining reports using Reports 6
• Writing embedded SQL using Sql*Pro tools
• Implementing and maintaining database security
• Database and application tuning, optimization and performance monitoring
• Capacity planning and sizing the database
• Establishing and maintaining sound backup and recovery policies and procedures

Confidential

Software Consultant

Responsibilities:

• Creating database structures, objects and their modification, as and when needed.
• Planning and writing scripts to automate backup and recovery.
• Backing up, restoring and recovering database and database objects.
• Documenting the day-to-day DBA activities.
• Tuning activities, monitoring and optimizing performance.
• Troubleshooting the Oracle database connectivity issues.
• Allocating system storage and planning future storage requirements.
• Maintaining copies of database to departmental servers.
• Deciding on the adoption of the latest technologies to the work environment as the technical team member.
• Creating various roles for users to identify what kind of access they need to have in the database.
• Assigning predefined profiles to the users to control CPU activity, idle time and quota management.

Confidential

Systems Analyst/DBA

Responsibilities:

• Creation of database structures, objects and their modification as and when needed.
• Managing users & roles for database security
• Maintaining system security, control and monitor user access to database
• Coding database triggers, functions and stored procedures using PL/SQL.
• Coding shell scripts for various administration activities including crontab entries for daily backup.
• Constantly monitoring of database for better performance of memory utilization, input/output, and processor management.
• Export and Import utilities used to backup and load the data.
• Backup done in hot and cold backup mode, restored hot backups.
• Functional specifications, prototyping, scheduling, coding, designing unit and system test plans, testing and implementation and quality assurance.
• Oracle database security implementation utilizing password verification, expiration and encryption, roles, privileges, fine-grained access control, synonyms, and DDL event triggers
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on tablespaces
• Database performance tuning including application design, SQL statements, PL/SQL procedures, database memory allocation and physical layout
• Installation of Oracle servers and applications on Unix/NT/Windows 2000 workstations
• Installing and managing SQL Server, Sybase and MS Access databases on NT workstations and PCs running Windows 95/98/2000
• Configuration of network communication among Oracle, SQL Server and MS Access databases, using SQL*Net, NET8, db links and ODBC driver
• Loading data into Oracle databases using export/import and SQL*loader
• Migration of a production database from Oracle 7.2.3 to 8.1.5