SUMMARY

• Having 8 Years of experience in IT industry working extensively in multiple roles that include Database Administrator (DBA), Database Support & Maintenance, Backup & Recovery, Reporting & Database performance Tuning, Mainframes operations and Teradata developer.
• Having 4+ Years of experience on Teradata Database Administration.
• Good understanding on Teradata architecture, Tools and Utilities. Currently working on TD 15 running on 4+2 Node, 6700 servers.
• Expertise in using WinDDI/Teradata Administrator for managing Databases, Users, managing permissions (Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user accounts etc.
• Experienced as on - call support DBA (24X7) as part of a scheduled rotation with other team members.
• Migration of objects from lower environment to higher environment, as part of the Application migration following the change management process.
• Reviewing of the objects as per the defined standards and discuss in the Change Board meeting.
• Execution of the adhoc DML requests thru a service request.
• Release locks on the stage tables, which are failed during ETL loading process.
• Collecting stats on the application tables thru a service request.
• On-boarding new applications as per the process and preparation of the database hierarchy along with respective roles and access rights.
• Space allocation for the new applications and capacity management.
• Expert in performance optimization techniques and SQL tuning. Good knowledge of PDCR and DBQL.
• Deploy various optimization methods to mitigate risks to performance and communicate them to the team.
• Ability to define/modify workload management standards (workload groups, throttles, priorities etc.) based on the needs of the day in production and explains the changes effectively to the team.
• Having Exposure with TDCH.
• Evaluates and implements new initiatives on technology and process improvement.
• Managing CPU,I/O, Spool and memory resources with
• Assist in Query Banding, Data Lineage for achieving better throughput and runtimes on Datastage, Informatica,OBIEE and SAS ETL
• Continuously improve and Optimize Performance and techniques with Forecasting Strategies for Applications in Pipeline
• Work for Implementing HA/DR Strategy on Teradata Appliance
• Continuously participate in Product Management, Technology Upgrades and Adherence to Newer Trends in Technology
• Excellent Communication and Interpersonal skills, ability to influence decisions based on DE best practices.
• Work closely with App teams, Database Teams to Adhere Product Specific Best Practices of RDBMS, tuning constraints within the Best Practices
• Work in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
• Work collaboratively with the database operations team and the vendor to resolve incidents and mitigate risks.
• Responsibility for gathering query, CPU & Disk resource requirements for new applications and extensions to existing systems.
• Assist in WLM, PDCR, DBQL, RESUSAGE, and Viewpoint modules.
• Application Code Review leveraging strong Teradata-SQL writing skills
• Exposure to Load utilities like TPUMP, FastLoad, FastExport, MLOAD.
• Assist for implementing retention and archival using TARA for archive and restore.
• Provide expert consultation to effectively interface with Teradata's GSC and manage service requests, incidents and problem resolution processes
• Enterprise level change management processes and procedures
• Support of upgrades and patches with accompanying Teradata vendor support
• Database Growth monitoring and Capacity planning.
• Good understanding on Teradata Work Load management concepts like TASM.
• Good understanding on Ferret utilities like Show locks, Lock display, RCV manager, Check table, Scan disk, Pack disk.
• Generating system heat map (performance and usage) reports.
• Defining space alerts on viewpoint for each application, Running Benchmarks on the system to monitor system performance.
• Having Experience in shell scripting using korn shell and Perl scripting.

TECHNICAL SKILLS

Database: Teradata 12, 13.10, 14.10, 15; Oracle 8i, 11g, SQL Server 2005,2008

Teradata: Teradata SQL Assistant, Teradata BTEQ, MultiLoad, FastLoad, FastExport, Tpump, Teradata Index Wizard, TPT Wizard, Teradata SQL Assistant, WinDDI/ Administrator, Viewpoint, Netbackup, TARA

OS/Scripts: UNIX/LINUX, RedHat Linux, Solaris, AIX, SuSe & Windows XP/NT

Scheduling: Tidal scheduling, crontab

Programming Languages: C, C++, Java, PL/SQL

PROFESSIONAL EXPERIENCE

Teradata DBA

Confidential, Charlotte, NC

Responsibilities:

• DDL Migration from lower environment to higher environment, i.e, DEV to QA and QA to PROD.
• Database administration on Teradata database in development and testing environments.
• Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Reviewing of the objects as per the defined standards and discuss in the Change Board meeting.
• Execution of the adhoc DML requests thru a service request.
• Release locks on the stage tables, which are failed during ETL loading process.
• Collecting stats on the application tables thru a service request.
• On-boarding new applications as per the process and preparation of the database hierarchy along with respective roles and access rights.
• Space allocation for the new applications and capacity management.
• Monitoring of daily, weekly backup jobs and in case of any issues, engage Teradata GSC for the issue.
• Identify and create indexes and collect statistics on tables.
• Performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning.
• Monitor database space, identify tables with high Skew and resolve similar issues by performing root cause analysis on load scripts.
• Performance tuning for problematic queries using DBQL and EXPLAIN.
• Responsible for day to day administration of Teradata databases.
• Promote presentation layer codes and solve day to day issuesand find opportunities to fine tune the SQL to improve the performance.
• Monitor database capacityand performance.
• Monitor jobs in development and testing environment using Viewpoint.
• Generating performance metrics reports by using DBQLOGTBL, DBQLSQLTBL AND DBQLOBJTBL .
• Helping development teams to trouble shoot the day to day issues.
• Handle the technical issues using incident management tool (HP service manager).

Environment: Teradata 15, Windows, Unix, Viewpoint Monitoring, ServiceNow, Netbackup.

Teradata DBA

Confidential

Responsibilities:

• Involved in complete SDLC (System Development Life Cycle).
• ExpertDBAskills inTeradataDBMS Administration, initial environment setup, development and production DBA support,TeradataManager, Viewpoint, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Established application hierarchies, databases, users, roles and profiles as per requirements.
• Responsible for performance monitoring, resource and priority management, space management, user management, index management, access control, execute disaster recovery procedures.
• Development and maintenance of complex SQL with multiple tables JOIN conditions. Involved in maintaining and troubleshooting problems for business applications.
• Loaded data using Fast Load, BTEQ, Fast Export, MultiLoad, and Korn shell scripts.
• Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain and enhance database performance usingTeradata Manager, Performance Monitor, and TASM.
• Teradatadatabase performance monitoring and maintenance, SupportTeradatadatabase & TTU upgrade activities, design, implement and co-ordinate all back-up, recovery (BAR) strategies.
• User and access Management, Space Management, Session Management, Index Management, System analysis, design & Maintenance.
• Assisted in troubleshooting the Production support problems, which are related withTeradata database.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell andTeradataSQL to transfer cleanup and summarize data.
• Directed MVS group on necessary changes to enhanceTeradataTDP performance, Ran Showspace to check for cylinder fragmentation and available free cylinders.

Environment: Teradata14.10,TeradataViewpoint,TeradataAdministrator, TARA GUI, Netbackup, TeradataVisual Explain, TeradataIndex Wizard.

Teradata Developer

Confidential

Responsibilities:

• Analyzed Business Requirements Document and Functional Specification document to develop detailed Test Plan and Test Cases.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• UsedTeradatautilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data.
• Worked on Stored procedures, macros, triggers and functions.
• Wrote, tested and implementedTeradataFastload, Multiload and Bteq scripts, DML and DDL.
• Wrote views based on user and/or reporting requirements.
• WroteTeradataMacros and used variousTeradataanalytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those toTeradata.
• Performance tuned and optimized various complex SQL queries.
• Good knowledge onTeradataManager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Agile team interaction.
• Worked with ET, UV tables and did performance tuning.
• Created appropriate indexes depend on the table situation and requirement.
• Worked with various types of tables such as Derived, Volatile, and Global temporary.
• Did data reconciliation in various source systems and in Teradata.
• Sometimes creating Unit test cases, Technical specifications etc according to the business specification or source map.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions etc.

Environment: Oracle 8i,Teradata12, 13.10,TeradataSQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT.

SQL Server Developer

Confidential

Responsibilities:

• InstalledSQLServer2008, 2005Servers, multi instances and service packs.
• Managed database backup and recovery, create database objects including tables, views, indexes.
• Experienced in troubleshooting, performance tuning, query tuning, and index tuning using DBCC command, Wizards andSQLProfiler.
• Set database access privileges for different users and user groups.
• Accomplished maintenance of clustered and non-clustered indexes.
• Developed DTS, SSIS Packages to transform data from excel file to SQL Server database.
• Worked in high availabilitySQLServersolutions, such as Mirroring, Log shipping, and Replication.
• Performed database consistency checks at regular intervals.
• MonitoredSQLServeractivity through profiler.
• Monitoredserverspace usage and generated reports.
• Developed standards forSQLServermaintenance / updates.
• Involved in Designing and implementing database maintenance plans.
• Performed tuning and optimizing queries and indexes.
• Set job scheduling, alert and E-mail notification.
• Maintained disaster recovery strategies for the database and fail-over methods.
• Co-ordinated and managed offshore team to ensure timely and quality delivery to the client and reviewing offshore deliverables.

Environment: SQLServer2008, 2005 Windows 2003Server, Access, Performance Monitor,SQLProfiler.