OBJECTIVE

• A hands - on Teradata & SQL Server Database Administrator with a proven track record of progressive management experience, team leadership and technical skills seeking a challenging role for professional growth and development.

SUMMARY

• Senior MS SQL Server DBA with 7+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2012/2008/R2/2005/2000 in Production, Testing and Development Environment’s.
• Experience in Data Migration from MS SQL server 2000/ /2008 R2.
• Extensive experience in Implementing, Upgrading, Migrating to SQL Server 2012
• Implemented AlwaysOn availability groups and replicas for reporting, backup and performance
• Expert in managing SQL Server in Physical and Virtual Environments
• Experience in implementing different types of Replication topologies involving Snapshot, and Transactional replication.
• Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.
• Implemented Sync and Async MIRRORING for Disaster Recovery Implementation
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like Veritas NetBackup, Sandpiper, TSM and LITESPEED.
• Expert in Using extensive SQL Server DMV's for performance tuning and Monitoring
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• Expert in implementing Full, Differential, Log and Compressed backups
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Expert in Creating, Deploying, Scheduling solid ETL Packages in SSIS
• Experience in creating reports in SSRS and deploying in various servers
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.
• Migrating Teradata database V2R5 to V2R6
• Administering Teradata database using Teradata Manager, Teradata Administrator
• Skilled on performing BAR activities using NetVault 7
• Teradata Explain, Stats Collection, Multi value Compression
• Performance tuning of Teradata SQL, ETL jobs
• Expertise in planning and implementing MS SQL server Security and database Permissions.
• Well aware of SOX compliance, SQL Server change control management and Reporting Services.
• Expert in T-SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views.

TECHNICAL SKILLS

Operating Systems: Win2000, Win2003, Win2008, WinXP, UNIX, UBUNTU

Database: MS SQL Server 2000/2005/2008/2008 R2/2012

Database Tools: VERITAS Net Backup, SQL Nexus, Perfmon, SQL Lite Speed 5.1, Red gate, Spotlight

Languages: T-Sql, Java, C#.NET, ASP.NET, VB.NET, MVC, Powershell

Networking: TCP/IP, LAN, WAN, Citrix, VM Ware-virtualization

Applications: Teradata Manager, PMON, Query Manager, Query Scheduler, IIS, Teradata Utilities, Teradata Statistics and Index Wizard

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr SQL DBA

Environment: Microsoft SQL Server 2005 and 2008, 2008 R2, 2012, VERITAS Netback up, MS Visual Studio.NET on Win Server 2003, Win Server 2008, BMC-Patrol.

Responsibilities:

• Responsible for supporting over 350 SQL instances which include SQL / 08 / R2 & 2012.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Installation of SSIS 2008R2 Active/Passive cluster on a Windows 2008R2 cluster and Performed in place upgrade of SSRS from R2.
• Installed SQL Server 2012 Cluster and configured ‘Always On’ availability group set up on Windows Server 2012 in Development & SIT environments.
• Configured\Monitored\Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication.
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked on Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Used Quest Lite speed to set up Log Shipping and create Backup Job’s.
• Implemented Pager options to inform corresponding DBA basis on each Job Status.
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Foglight Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
• Define db scripts versioning system to keep track of database versions for all environments.

Confidential, Southborough, MA

Teradata/SQL DBA

Environment: Teradata Manager, PMON, Teradata Utilities(BTEQ, SQL Assistant, TPump, FastLoad, MultiLoad, FastExport), Teradata Visual Explain, Index wizard, Veritas Netbackup, ARCMAIN

Responsibilities:

• Acting as an Onsite coordinator and working to resolve issues. Experience in performing production support for Teradata environments.
• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
• To proactively monitor the database systems to ensure secure services with minimum downtime and responsible to meet the SLA’s.
• Capable of supporting and implementing technology projects as the primary DBA in support of business initiatives
• Primary maintenance support for production and development databases with respect to monitoring the Teradata Manager, PMON window and collecting stats when required for particular databases.
• Check on PERM and SPOOL spaces with respect to the database.
• Performed database installs and upgrades, performance tuning, analyzed performance issues, setup of user access, backup and recovery.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Develop archival, backup and recovery strategy. Plan, perform and monitor database backups. Performing backup and restore operations of Teradata databases using NetVault and ARCHMAIN. Provide 24x7 on call production support.
• Knowledge in Fastload, Multiload, TPUMP, FastExport and BTEQ scripts
• Analyze job failures in VERITAS and check media drives and tape drives when they are down.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

Confidential, Englewood, CO

Sr. SQL DBA

Environment: SQL Server 2005, SQL Server 2008R2, 2008SQL Server R2, DTS, T-SQL, ERWIN, SSIS, Windows Server 2008,2003, MS Access, Excel, HTML, JavaScript, BCP, Spot Light.

Responsibilities:

• Created groups, roles, users and assigning access privileges to users.
• Created user defined data types and added them to model database for future purpose.
• Creating stored procedures, implemented referential integrity by using triggers.
• Involved in migration from sql server 2000 to sql server 2005.
• Logical and physical database design using Erwin Data Modeling Tool.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested backup strategies.
• Implemented automated backup and database maintenance/cleanup jobs.
• Performed ETL to support data loads and transformations using DTS Packages and SSIS.
• Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Implemented, deployed and maintained Log Shipping.
• Performed DBCC utilities and fixed data corruption in application databases
• Provided on - call 24/7 support.
• Provided support for in-house and offshore Development Team.

Confidential, San Jose, CA

Sr. SQL DBA

Environment: Windows 2000/2003, SQL Server 2005 and 2008R2, Windows Enterprise Server 2003, Microsoft Reporting Services.

Responsibilities:

• Performed backup using backup compression and Data compression in SQL Server 2008R2 on clustered environment.
• Involved in Scheduling the Reports to run on daily and weekly basis in Report Manager.
• Relocation of Databases from one server to another server using attach and detach databases.
• Hand on experience in maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
• Responsible for helping design, model, and architecture of Data Warehousing, Data Governance, and Business Intelligence solutions for the client.
• Experience in Design and Architecture of an Enterprises Data Warehouse.
• Administrated and managed the SQL Server 2008R2, 2005 production and Non-production servers.
• Migrated SQL Server 2005 databases to SQL Server 2008R2 databases including DTS to SSIS packages.
• Implemented new features in SQL 2008R2 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
• Implemented high availability on the various servers using replication and mirroring.
• Implemented and tested the point in time recovery of the production databases.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources like SQL Server using SSIS.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering and documentation.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored Log shipping and Transactional Replication and trouble shooting of errors.

Confidential

SQL Server

Environment: Microsoft SQL Server 7.0/ 2000/2005 , Windows 2000 server, TSQL, DTS

Responsibilities:

• Responsible for installation and configuration and up gradation of SQL server 7.0 to database on Windows Servers.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Requested refreshes pre or post restore activities (e.g. data loads).
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Proven ability to handle Database of more than 1 TB in Size.
• Perform day-to-day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Estimating of Table sizes and Record sizes. Maintaining proper licenses.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Scheduling and managing jobs on MS SQL Server and manage database security with respect to User access, roles and privileges.
• Maintain all the SQL documents include installation, Security guidelines, hardening guidelines and data conversion Procedures documents.

Confidential

SQL Server

Environment: SQL Server 2000, SQL DB Access, Performance Monitor, Backup Utility, Windows 2003, SQL Profiler.

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Involved in creating Stored Procedures, views, tables, constrains.
• Monitoring the server for High availability of the servers.
• Created stored procedures and triggers for Data consistency.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Service.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Participate in implementation of new releases into production.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Day-to-day administration of live SQL Servers.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Designed and implemented Security policy for SQL Servers
• Responsible for monitoring and making recommendations for performance improvement in hosted databases like index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Used Stored Procedures, DTS packages, BCP for updating Servers
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Using Log shipping for synchronization of database.
• Worked in Cluster Environment.