SUMMARY

• 5+ years of experience in Database Administration for large and complex databases in SQL Server 2008/2005/2000.
• Expertise in installing MS SQL Server 2000, 2005 and 2008, updating wif latest service packs and security patches.
• Knowledge about MS SQL Server 2012 it is more advanced, fast pace and high flexibility on demand than last versions.
• Prepared maintained and modified SQL server installation documents.
• Dexterity inimplementingdifferent types ofHigh Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping,Database Mirroring and Clustering.
• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Creating SQL databases technical documentation.
• Expertise inDatabase AdministrationonProduction Serverswifserver configuration, performance tuningandmaintenancewifoutstanding troubleshooting capabilities
• Prepared maintained and modified SQL server configuration documents
• Exquisite skills in database Backup, Restoration, Recovery, Replication, Linked Servers, Database Maintenance Planning.
• Acquaintance wif teh new features of SQL 2008 like Activity Monitor, Intelligence, SQL Server Audit, Backup Compression, Data Compression, Central Management Servers, Data Collector, Policy - Based Management, Plan Guides, Full-text search and Resource Governor.
• Worked on32 bit and 64 bitSQL Server andMSCSConfigurations.
• Dexterity inimplementingdifferent types ofHigh Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping,Database Mirroring and Clustering.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity.
• Outstanding experience inSQLEnterprises Manager and SSMS - creating and scheduling jobs, alert and operators wifSQL Server Agent,SQL Profiler, Backup/Recovery databases.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Expertness in trouble shooting database issues likespace issues, deadlocks, performance and blocking.
• Soundnoledge stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
• Buildcomplex SQL queries (ex: using various joins andsub-queries) and stored procedures.
• Prowess in planning and implementingDatabase Securityby creating users, Roles, and assigning permissions to them.
• Conversion,Conditional Split,Bulk Insert, OLEDB Command andMerge.
• UsedFiltered Indexesfor improving query performance, lower storage and maintenance cost.
• Handled numerous change management requests on production servers.
• Prepared maintained and modified SQL server installation documents.
• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Creating SQL databases technical documentation.
• Acquaintance wif teh new features of SQL 2008 like Activity Monitor, Intelligence, SQL Server Audit, Backup Compression, Data Compression, Central Management Servers, Data Collector, Policy-Based Management, Plan Guides, Full-text search and Resource Governor.
• Worked on32 bit and 64 bitSQL Server andMSCSConfigurations.
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevels
• Experience in CreatingReport Subscription,Data Driven Subscription, Report Snapshotsand caching, linked, cascadedandparameterized reports, complex drill down reportsusingSQL Server.
• Experience in CreatingReport Subscription,Data Driven Subscription, and Report Snapshots usingSQL Server reporting services.
• Strong Experience wifOLTPandOLAPEnvironment.
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2000, 2005, 2008/2008R2/2012

Programming: Visual Basic

DBA: Administration of MS SQL Server 2000, 2005, 2008 databases

Operating System: Windows 2008/2005/2003/2000 Advanced Server, NT.

Network Topology: TCP/IP

Tools: /Utility: Backup Utility, Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, SQL Profiler.

Other Tools: MS Office (Microsoft Word, Excel, and PowerPoint)

Reporting Tools: Excel, SQL Server Reporting Services 2008,2005

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on teh financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• Monitored and tuned databases to meet teh performance and availability requirements of on-line systems and multiple applications.
• Performed Database Refresh tasks from production to Development and Staging Servers
• Modified database structures including tables, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures.
• Checked teh configuration and performance of teh existing databases including data file allocation, index fill factor, fragmentation and teh impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.) to avoid and optimize.
• Developed and created teh new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on teh existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into teh databases.
• Configured teh new servers using failover clustering and SAN technology.
• Migrated all teh databases from old servers to new servers to test for a month.
• Generated test data and tested new databases consistency wif existing databases to meet teh functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.

Confidential, Charlotte, NC

SQL SERVER DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Prepared maintained and modified SQL server installation and configuration documents
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Involved in teh migration ofSQL Server 2000 databases to SQL Server 2005.
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor teh performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Evaluated data storage considerations to store databases andtransaction logs. Created databases usingTransact SQL Statements,SQL Server Management StudioandDatabase Wizard.
• Implemented newT-SQLfeatures added inSQL Server 2005that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Identified, tested and resolveddatabase performance issues (monitoring and tuning)to ensuredata optimization.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Managed trouble shooting ofClient connections, viewing error log and applications.
• Developedautomated backup and DBCC scriptsfor databases and transaction logs.
• Maintaining teh databaseconsistencywifDBCCutility at regular intervals.
• Worked on log shipping for synchronization of database.
• Worked inCluster Environment.
• Authenticated logins and validated permissions. Created SQL Server Databaseusers and Roles.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Involved indatabase Normalization, logical and physicaldata modelingusingERWIN.
• Created and supportedcomplex database schemas.
• Used SQL Profiler to capture teh activities of teh databases and used teh trace file as workload file to teh Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Transferred data (ETL) toData warehouse Environment using SSIS.
• Involved in SourceData Analysis, analysis and designing mappings for data extractionalso responsible forDesign and Development of SSIS Packagesto load teh Data from various Databases and Files.
• Worked onDTS, Import and Exportutility, for transferring data.
• Installed, authored, andmanaged reports using SQL Server 2005 Reporting Services
• ConfiguredSQL Server settingsusing configuration manager.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server, .XML,Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS), JAVA,J2EE

Confidential, St Louis, MO

Jr SQL DBA

Responsibilities:

• Experience in installing and configuring Windows and SQL clusters.
• Performed regular Database Maintenance task, checking teh disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server wif Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of teh SQL Server for Web based Production and Development environments
• Performed Database consistency checks wif DBCC, Defrag, Index tuning and monitored SQL Server error logs

Environment: MS SQL Server 2000/2005, SQL Profiler, Windows NT/2003, VERITAS Net Backup and Crystal Reports.