SUMMARY

• 7+ of IT experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/server applications.
• Around 5 years’ experience in MS SQL Server 2012/2008R 2/2008/2005/2000 and hands on experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling using Erwin, MS Visio.
• Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
• Experienced T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Data Import/Export, Triggers, and Cursors.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experience inperformance tuningin SSIS packages by using row transformations.
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Having good experience in creating, modifying, using and debugging Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Experience in report writing usingSQLServer Reporting Services (SSRS)and creating various types of reportslike Table, Matrix, Drill Down, Drill Through and Cascaded reports.
• Experience in report writing usingSQLServer Reporting Services (SSRS)and creating various types of reportslike Table, Matrix, Drill Down, Drill Through and Cascaded reports
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Extracted data from databases like Oracle, Teradata, Sybase and MySQL and migrated into SQL server using SSIS.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Having Experience onata center servers and handling 1.4 TB databases.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

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

Programming: Visual Basic 6, PowerShell script, Visual Basic 5, C, C++ & SQL, XML, HTML.

DBA: Data Base Administration of MS SQL Server 2012, 2008R2, 2008, 2005, 2000.

Operating System: Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux.

Programming /scripting: T-SQL, JOIN, Stored Procedures, Trigger, Function.

Tools: Backup Utility, SQL Lite Speed, Visio, Erwin, DB Moto.

Network Topologies: TCP/IP, WINS, DNS, DHCP, FTP, SNMP, SMTP.

Data Modeling Tools: Erwin, VISIO, Toad Data Modeler, SSD (SQL Server Database DiagramOperating System Windows Server 2008R2, 2008, 2003 and Windows 7 Professional, Windows XP Professional.

Business Intelligent Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, SSAS.

PROFESSIONAL EXPERIENCE

Confidential, Newport Beach, CA

SQL DBA

Responsibilities:

• Actively involved in daily production DBA activities and participated in on-call rotations.
• Managed nearly 10 TB VLDB using partition tables and implemented row and table compression as a part of database reduction policy.
• Actively involved in resolving concurrency, locking issues by killing sessions and helping app team for query tuning and re-running process.
• Deployed SQL Server 2012 by upgrading existing SQL 2008R2 & 2008 environments using command line automated installation method (In-place upgrade).
• Implemented SQL Server Always on availability groups as part of HA and DR solutions and documented all necessary steps and coordinated with other team members.
• Successful implementation of SQL Server Always on clustering by coordinating with AD Admins for all setup and monitoring of the Windows Failover Clustering.
• Implemented Solarwinds DPA alerting tool for all SQL instances and did all configurations related to both for reporting and alerting.
• Created custom SSIS jobs that are involved in data pushing from ORACLE SQL Server and vice versa using native SQL drivers and ODBC connections
• Actively involved in database consolidation project by co-ordination with app team and documenting necessary steps, also retired old databases as part of this project as well.
• Updated current refresh process using PowerShell, which is more granular and clean.
• Updated monitoring scripts with new DMV’s that are specific to SQL 2012 instances.
• Retried old SAN snapshots and replaced Log-shipping as a part of DR strategy.
• Implemented log-shipping alerting and monitoring scripts and created necessary alerting mechanisms.
• Co-ordinated with Change Management team in pushing code to production from SVN.
• Actively involved in query performance tuning by re-writing query, creating necessary indexes and disabling unnecessary indexes.
• Troubleshooting and fixing server performance issues by looking into memory, CPU usage and coordinating with app team to reduce unnecessary load.
• Implemented necessary security permissions at both server and database level and coordinated with windows admin for all necessary standards for service accounts.
• Helped with tuning server configuration parameters with necessary values and helping in index rebuild/reorganize, database DBCC check for any corruptions.
• Co-ordinated with ORACLE DBA’s for Golden Gate replication from SQL Server to Oracle by managing secondary truncation point.
• Actively involved all team internal discussions for new requests from app team and involved in database migration/retirement strategies.

Environment: MSSQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, Replication, Sybase ASE 12.5/15.7, PowerShell v4.5, 3.0,Solarwinds, Spot Light, Fog Light, SQLLite speed console, SQLsentry.

Confidential, Bloomington, IL

SQL Server DBA

Responsibilities:

• Installing, configuring and administration of SQL ServerDatabases 2008/2012.
• Worked under Active/Passive and Active/Active cluster environment. Analyzed results of the tests by creating reports.
• Performed patching to maintain current versions of SQL.
• Managing SQL server usingPowerShell scripts.
• Performed Administrative tasks in SQL Server usingPowerShell.
• Worked withPowerShell for performance enhancement and security audits.
• Developed Windows PowerShell script to automate setting of user credentials and activation ofWindows.
• Worked On Always ON Environment.
• Implemented transactional replication and mirroring on part of Always On Availability Group.
• Actively participated in migration of databases from and 2012.
• Supported Customer service databases which are more than 2TB.
• Expertise in designing databases and capacity planning.
• Working on data mining and Microsoft analysis services.
• Analyzed results of the tests by creating reports
• Implementation of SQLLogins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Played an active role in requirements gathering, blueprint, design, configuration, project reviews with users and sign offs.
• Rebuilding the indexes at regular intervals for better performance.
• Updating/Deleting File stream Data.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the VERITAS net backups.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Complete documentation about the database
• Designed and created databases, tables, views, store procedures and triggers.
• Developed various views and functionalities for the Affinity Compensation system department according to their specification.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.
• Created DTS packages for migration of data fromSQL Server to MS Access or Oracle Databases.
• Wrote optimized T-SQLstored procedure to improve performance, preserve referential integrity and provide application functionality.
• Created groups, roles, users and assigned access privileges to users.
• Exported and imported data from text files and Excel T- SQL Serverdatabase using bulk copy insert and BCP utility.
• Tuned the performance of SQL queries and Stored procedures using SQLProfiler and Index Tuning Wizard.
• Scheduled jobs and alerts usingSQL Server Agent.

Environment: MS SQL Server 2012/2008, Windows 2000/2003 servers, Active Directory, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, Diagnostic Manager, Microsoft Reporting Services, UNIX, PowerShell, Microsoft SQL Server Integration Services(SSIS), Lite speed

Confidential, Fairfield, CT

SQL Server DBA

Responsibilities:

• Responsible for MS SQL Server 2008 R2, configuration, tuning and provide24 X 7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• ConfiguredTransactional replicationbetween Primary Server and three Read - Only servers, with separate Distributor server and experience introubleshooting replication problems.
• Resolved the SQL Server 2008 upgrade hurdles and successfullyMigrated SQL 2005 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
• For complex packages like password protected packages, packages created using SQL Native client usedDTS Xchange tool.
• Data Transformation Activities usingSSIS Import/ Exportfor transferring data between different databases likeoracle. Design new SSIS packages as per needs, Resolve the problems.
• Generated different types ofReports(Tabular/Matrix) usingMS SQL Server Reporting Service (SSRS).
• Designing and Optimizing all the SSIS packages
• Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Additionally, designed and implemented adisaster recoverysystem.
• RunningIndex tuning wizard and rebuilding indexesfor faster query response.
• Assignpermissionto user(s), role(s), and object. Support column level permission. Administrate security for server's logins (Windows and SQL Accounts).
• Prepared Estimates for Database, table size growth.
• Created documentation to install SQL Server, applyservice pack, hot fix and clustering installation.
• Expertise inSecurity Issuessuch as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Wrote and integrated Stored Procedures to generate the Reports.

Environment: Windows 2008 Server, SQL Enterprise Edition, Oracle 10g,SSRS, SSAS, SSIS, Performance Point Sever 2007,T-SQL,ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential, New York, NY

SQL Server DBA\ Developer

Responsibilities:

• Perform database create, administer and maintain databases and servers.
• Created and maintained user, user groups, files and files groups.
• Install and patch server software, upgrade and downgrade databases.
• Implement disaster recovery strategies like Log shipping and Replication (snapshot, transaction, merge) between servers.
• Performed database backup/restore, attach/detach application and operating performance monitoring and tuning, identify and resolve any database bottlenecks proactively, respond to raised problems quickly.
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization.
• Involved in database index reorganization and rebuilding.
• Design, creation, configuration, recovery and support of SQL Server databases.
• Performed Production support by troubleshooting database issues, performance monitoring and tuning for SQL Server databases.

Environment: MS SQL Server 2005/2008, Windows 2000/2003 servers, Active Directory, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, Diagnostic Manager, Microsoft Reporting Services, UNIX, PowerShell, Microsoft SQL Server Integration Services(SSIS), Lite speed