SUMMARY:

A seasoned Database Administrator experienced with TERADATA Datawarehousing and MySQL (4.0 and above). Doing well in Database configuration, maintenance, performance tuning, monitoring, Backup and Recovery. Knowledgeable also with other databases such as SQL Server (2000/2005/2008 ) and Oracle (Exadata/11g), programming using PERL and knowledgeable in Linux System Administration and OBIEE. Have been a Sr.DBA who handles and supervise Junior DBA's.

KEY SKILLS:

• Good DBA skills in DBMS production DBA support.
• Skilled in performance tuning
• Skilled on performing backup and recovery
• Skilled on UNIX environment and standard tools such as VI, Unix commands, utilities, Shell scripting etc.

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Database Administrator/Platform Support Analyst

Responsibilities:

• Monitor system performance via viewpoint
• Perform object creation (data lab databases/Tables/Views/Macros) and user management
• Create application roles and profiles depending on the requirement of the project
• Performance tuning and troubleshooting of adhoc/suspect queries and issues regarding backup/recovery and Data mover
• Create monthly/weekly reports for database performance, space and BAR
• Create Backup/restore scripts using DSA/Netbackup
• Backup Scheduling and inventory of tapes
• Monitoring of batch jobs and coordinating to application owner for any issue
• Create incident/change ticket using remedy for any issue to manage properly
• Design and monitor alerts, database parameters, and performance metrics
• Perform database space maintenance (spool space, database space)

Confidential

Teradata/Exadata Database Administrator

Responsibilities:

• Setup DEV/QA databases
• Perform object creation
• Perform user management
• Perform database purging and archiving
• Database Restoration and Recovery
• Perform database refresh or overlay of QA and Dev database from Production database
• Provision Test environment
• Performance tuning on offending queries
• Performance tuning on table level

Confidential

Associate Technical Consultant (DBA)

Responsibilities:

• Oversee successful management of database privileges for users, groups, profiles as part access control
• Design and monitor alerts, database parameters, and performance metrics
• Perform complex DDL implementations, such as creation and change database objects (i.e. table, index, views and etc.)
• Develop stored procedures and triggers
• Participate in complex designing and management of data archiving, backup and restoration
• Determine choke points, system slow down, contention, and or database transaction blockings
• Perform database space maintenance (spool space, database space)
• Perform advanced database tuning approaches and practices
• Monitor the team’s Incident and Change Management queues, ensuring that tickets and requests are properly implemented, performed or resolved within its SLA
• Provide expertise in resolving complicated incidents or issues
• Produce technical documentation that will help in optimizing the team’s support functions.

Confidential

Senior Database Administrator

Responsibilities:

• Maintain the game databases of the company, make sure it is accessible 24X7.
• Performs database server maintenance such as disk space usage, network connection and technical things with concern to the machine.
• Allocating system storage and planning future storage requirements for the database system.
• Managing primary database structures and objects such as tablespace, tables, views and indexes.
• Checks database users and maintain system security.
• Controlling and monitoring user access to the database.
• Optimize and monitor the performance of the database.
• Create Stored Procedures and Triggers for developers.
• Data mining for statistics reports.
• Handles/Guides jr.DBAs in creating stored procedures and triggers

Confidential

Database Administrator

Responsibilities:

• Administer/Manage databases of the company.
• Monitoring of Alert log for database errors or problems.
• Database creation and design for web/application projects.
• Perform backup and restore of database.
• Creation of users and assigning database access rights and privileges.
• Creating and dropping of schemas and other database objects.
• Create stored procedures and triggers for developers.
• Create Database Replication.
• Analyze,investigate,resolve technical issues regarding customer/client request.
• Creation of daily,weekly,monthly statistics reports.
• Working closely with IT managers and web developers.

Confidential

Junior Database Administrator

Responsibilities:

• Installation and configuration of Database.
• Implement backup and recovery for internal and project databases
• Perform Database Tuning and Optimization
• Plan database capacity, storage capacity and backup capacity
• Ensure the storage, archiving, backup and recovery procedures are functioning correctly
• Performs Database migration and replication.
• Creates Database for web/application projects.
• Creates Stored Procedures and Triggers.
• Creates Functions using PERL for statistics reports.
• Ensures Database security.
• Working closely with IT managers and web developers.