SUMMARY

• I have 14 years of experience as a database administrator, administering databases including Oracle 9i / 10g, Teradata 12, 13.10, 14.10, 15.10 and 16.20 on various OS platforms. I am currently working with Confidential as Teradata Database Administrator for Confidential.
• Worked for 5 years as Oracle DBA and 9 years as Teradata DBA.
• Experienced in databases creation and configuration, PDCR installation and configuration, Space management, User management, data synchronization across systems, monitoring sessions and resolving session conflicts, performance analysis and reporting, Backup and Recovery, query tuning and optimization, MVC, migrating and upgrading databases, UNIX shell - scripting, developing & scheduling batch jobs, Service management.
• Create and maintain user/role/DB objects, Analyze and research database-related issues, Measure performance matrix, Monitor and execute ETL jobs, grant and revoke object/system rights on databases/users/roles, Monitor session, nodes, and virtual processes through PMON and Viewpoint, Reallocate disk space, Perform back-up job scripting and monitoring through TARA GUI, DSA, Investigate space usage and monitor growth of the databases, Release HUT Locks and M-Load, and resolve spool out issues.

TECHNICAL SKILLS

• C, C++, SQL, VB, HTML and Unix Shell scripting
• Windows, UNIX, AIX and Linux
• Oracle 8i, 9i & 10g, Teradata 12, 13.10, 14.10, 15.10 and 16.20
• Viewpoint, Performance Data Collection & Reporting (PDCR), Teradata Studio, Teradata SQL Assistant, BTEQ
• Fast load, Multiload, Teradata Manager, Data Mover, Teradata Active System Management (TASM), TARA
• Data Stream Architecture (DSA), PMON, ARCMAIN, TD Administrator, Teradata Workload designer, Data Mover
• Microsoft Office, Oracle Enterprise Manager (OEM), TOAD, SQL loader, Microsoft Visual Source Safe (VSS)
• Imp and Exp, Datapump, IMPDP & EXPDP, Oracle SQL analyzes, SQL*Plus, RMAN & ControlM

PROFESSIONAL EXPERIENCE

Teradata DBA

Confidential, Houston, Texas

Responsibilities:

• Teradata Database administration including: User/Role/DB creation and maintenance, Synchronization of UAT databases with production, Database objects creation and maintenance, Analyzing and research on any database related issues, Measurement of Performance matrix, Monitoring and execution of ETL jobs, Incident creation and follow-up, Granting & Revoking of Object/System Rights on Databases/Users/Roles, Monitoring of Sessions, Nodes, and Vprocs through PMON and Viewpoint, Reallocating Disk Space, Backup job scripting and monitoring through DSA, Investigating Space Usage & Monitoring the growth of the databases, Releasing Hut Locks, Releasing M-load and Resolving Spool out Issues.
• Onsite-offshore coordination, Service Management and client coordination.
• Planning and implementation of TD16.20 DBS upgrade from 15.10.
• PDCR 16.20 installation and data migration from 15.10.

Confidential, Richmond, Virginia

Responsibilities:

• Lead for team of 6, onsite-offshore coordination, Service Management and client coordination.
• Planning and implementation of 15.10 upgrade (BAR, ViewPoint and Database). Including pre-upgrade assessment, scandisk, checktable, reserved words check, DBC control parameters comparison, stats and DDL backup, access grant script preparation, etc. Coordinating preparation and testing of TD14.10 new features test scripts and execution. Post-Upgrade assessment reports for TDDEV and PROD after upgrade to TD15.10. TD Wallet Implementation across the AIX Servers.
• Created and maintained shift roster for each team member kept track of activities performed by team members on day to day basis. Onsite and Offshore task assignment and team coordination.
• Coordinated scripting various Unix Alert/Reporting/Automation jobs. Defined space alerts in ViewPoint for all databases reaching peak
• MVC implementation, collection of PI columns stats, SET tables to MULTISET tables conversion and other space management activities.
• Partition extension of all the partitioned tables/join indexes during yearend.
• Identified and dropped unused and backup/temp tables from the system.
• Worked with performance DBA to develop and maintain job jar for performance DBA activities.
• Weekly/Monthly and Quarterly analysis and preparation of CPU, I/O and AWT Utilization Reports. Documenting and reporting Issues, Risk and Action (IRA) log, Monthly SLA and Resource Utilization and performance analysis and reporting.
• Carried out day to day database support activities including: User/Role/DB Objects creation and maintenance, Synchronization of UAT databases with production, Database objects creation and maintenance, Analyzing and research on any database related issues, Measurement of Performance matrix, Monitoring and execution of ETL jobs, Incident creation and follow-up, Granting & Revoking of Object/System Rights on Databases/Users/Roles, Monitoring of Sessions, Nodes, and Vprocs through PMON and Viewpoint, Reallocating Disk Space, Backup job scripting and monitoring through TARA GUI, Investigating Space Usage & Monitoring the growth of the databases, Releasing Hut Locks, Releasing M-load and Resolving Spool out Issues.

Confidential

PS Consultant

Responsibilities:

• Lead for team of 8, onsite-offshore coordination, Service Management and client coordination. Management of shifts and kept track of activities performed by team members on day to day basis. Onsite and Offshore task assignment and team coordination.
• Planning and implementation of TD14.10 upgrade (BAR, ViewPoint and Database). Pre-upgrade assessment including scandisk, checktable, reserved words check, DBC control parameters comparison, stats and DDL backup, access grant script preparation, etc.
• Carried out full system backup and restore of PROD system into building new QA system during TD14.10 upgrade. Prepared NPARC migration plan considering space limit. Coordinated preparation and testing of TD14.10 new features test scripts and execution. Generated Post-Upgrade assessment reports for TDDEV and PROD after upgrade to TD14.10. TD Wallet Implementation across the AIX Servers.
• Coordinated DataMover job automation using UNIX shell scripting and its proper documentation in the work flow on SharePoint. Coordinated scripting various Unix Alert/Reporting/Automation jobs. Defined space alerts in ViewPoint for all databases reaching peak
• Installed PDCR on QA and Appliance systems.
• Co-ordinated with TSM for resolution of BAR backup issues to get backups running smoothly.
• Worked with performance DBA to develop and maintain job jar for performance DBA activities.
• Carried out day to day database support activities including: User/Role/DB Objects creation and maintenance, Synchronization of UAT databases with production, Database objects creation and maintenance, Analyzing and research on any database related issues, Measurement of Performance matrix, Monitoring and execution of ETL jobs, Incident creation and follow-up, Granting & Revoking of Object/System Rights on Databases/Users/Roles, Monitoring of Sessions, Nodes, and Vprocs through PMON and Viewpoint, Reallocating Disk Space, Backup job scripting and monitoring through TARA GUI, Investigating Space Usage & Monitoring the growth of the databases, Releasing Hut Locks, Releasing M-load and Resolving Spool out Issues.

Confidential

Associate lead Technical Consultant

Responsibilities:

• Planning and implementation of TD13.10 upgrade, migration of alerts and jobs from Teradata Manager Server to ViewPoint during TD13.10 upgrade. Executed pre-upgrade assessment including scandisk, checktable, reserved words check, DBC control parameters comparison, stats and DDL backup, access grant script preparation, etc. Coordinated preparation and testing of TD13.10 new features test scripts and execution. Generated Post-Upgrade assessment reports for TDDEV and PROD after upgrade to TD13.10.
• Coordinated scripting various Unix Alert/Reporting/Automation jobs. Backup jobs standardization. Modified and rescheduled BAR Jobs as per the analysis done on completion time of backup jobs. Defined space alerts in ViewPoint for all databases reaching peak
• Identified and dropped unused and backup/temp tables from the system.
• Co-ordinated with TSM for resolution of BAR backup issues to get backups running smoothly.
• Worked with performance DBA to develop and maintain job jar for performance DBA activities.
• Weekly/Monthly and Quarterly analysis and preparation of CPU, I/O and AWT Utilization Reports. Documenting and reporting Issues, Risk and Action (IRA) log, Monthly SLA and Resource Utilization and performance analysis and reporting.
• Carried out day to day database support activities including: User/Role/DB Objects creation and maintenance, Synchronization of UAT databases with production, Database objects creation and maintenance, Analyzing and research on any database related issues, Measurement of Performance matrix, Monitoring and execution of ETL jobs, Incident creation and follow-up, Granting & Revoking of Object/System Rights on Databases/Users/Roles, Monitoring of Sessions, Nodes, and Vprocs through PMON and Viewpoint, Reallocating Disk Space, Backup job scripting and monitoring through TARA GUI, Investigating Space Usage & Monitoring the growth of the databases, Releasing Hut Locks, Releasing M-load and Resolving Spool out Issues.

Confidential

Database Administrator

Responsibilities:

• Database support to 600+ databases, 180 Prod and 400+ Development and Test dbs.
• Creation/Migration/Cloning databases. Reorganizing database objects (table re-organization and index rebuilds). Analyzing database tables /indexes/partitions maintenance. Maintenance and reorganization of DB objects, partitioned tables and maintenance. Capacity planning for Database/ tablespace growth.
• Creating and Managing database objects, Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security. Database/Schema refreshes using datapump.
• Troubleshooting and maintenance of Databases, analyzing and research on any database related issues. Monitoring tablespace usage and alert log files for ORA related errors
• Scheduling and managing database jobs, cron jobs and jobs running through ControlM.
• Oracle s/w installation/upgrades/patching, DB creation and environment setup.
• Database backups with RMAN, TTS and EXP(DP) utility. Backup restoration with VERITAS net backup (character-based interface - bp)
• Writing Shell scripts for daily DB monitoring, maintenance and database backups. Development/Modification/Debugging of PL/SQL Packages/Procedures.
• Data loading/unloading with SQL loader, EXP/IMP and EXPDP/IMPDP utilities.
• SQL tuning with EXPLAIN PLAN, SQL TRACE and TKPROF utility.
• Database user/role/access management to maintain security. Database auditing implementation and report generation for high privileged users.

Confidential

Database Administrator

Responsibilities:

• Synchronization TEST database (UAT) with production
• Database objects creation and maintenance, reorganizing database objects (table re-organization and index rebuilds)
• Analyzing and research on any database related issues
• Measuring the Performance matrix for each phase and comparison studies.
• Refreshing the different Schemas
• Creating backup tables of each phase in PPLADA (After refresh from LIVE)
• Migration of data from UAT to LIVE.
• Data loading through Excel/CSV documents using SQL-LOADER
• Release scripts preparation and maintenance
• GSD request creation and follow-up.
• Keeping the release scripts, logs and performance tuning scripts/logs in MKS
• Performance tuning