SUMMARY

• More than 7+ Years of experience in Information Technology as a Database Administrator, Database Developer and as a Software Programmer.
• Strong Experience in Administrating and Supporting MS SQL Server 2012 / 2008R 2 / 2008 / 2005 / 2000 in Production, Development and Test Environments.
• Experience in Installation, Configuration & Maintenance of MS SQL Server 2012 / 2008 R2 / 2008 / 2005 and 2000 Versions.
• Experience in Troubleshooting and Resolving Database Integrity issues, Performance issues, Blocking and Deadlock issues, Replication issues, Log Shipping issues, Connectivity issues and Security issues etc.
• Experience In Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in Performance Monitoring and Performance Tuning by implementing efficient Schemas, Optimizing queries, Tuning indexes.
• Experience in Detecting and Troubleshooting SQL Server related CPU, Memory, I/O, Disk Space and other Resource contention issues.
• Experience in writing and Troubleshooting SQL Code, Stored Procs, Functions, Tables, Views, Triggers, Indexes and Constraints.
• Experience in Designing, testing and implementing High Availability solutions for databases.
• Experience in Implementing HADR AlwaysOn Solution using FCI and Availability Groups.
• Experience in Implementing High Availability solutions using SQL Server Clustering, Database Mirroring and Log Shipping.
• Experience in Administrating Failover Clustering in Active/Passive environment.
• Experience in Implementing Transactional \ Merge \ Snapshot Replications in between Production SQL Servers.
• Experience in Migrating and Upgrading SQL7/SQL2000/2005 environments to SQL Server 2012 \ SQL Server 2008 and SQL Server 2008 R2 environments.
• Worked on more than 60 Database Migration and Upgrade Projects.
• Handled multiple medium to large scale projects with minimal direction and supervision.
• Experience in Logical and Physical Data Modelling and Schema design.
• Experience in Implementing SSIS, SSAS and SSRS solutions for Enterprise requirements.
• Experience in Designing and Configuration of Cubes using SQL Server Analysis Services (SSAS).
• Experience in designing, creating, processing of cubes using SSAS.
• Experience in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user - defined functions.
• Experience in Designing Aggregations and pre-calculating the same in SSAS.
• Installed and managed reports using SQL Server 2012 \ 2008R2 Reporting Services.
• Experience in generating reports using MS Reporting Services 2012/2008.
• Experience in configuration of report server and report manager, giving permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled based reports using SQL Server Reporting Services.
• Excellent command on subscriptions, report snapshot and report cache.
• Excellent skills in implementing ETL Solutions using DTS and SSIS.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in creating master and child packages, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.
• Experience in writing VB scripts in script component task.
• Experience in Migrating DTS packages to SSIS and modified using DTS editor wizard.
• Experience in Data transfer (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP).
• Experience in Installing, Configuring and Managing MSDTC Instances in Cluster environment and experience in writing Distributed Queries.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using SSIS and Linked Server.
• Designed and Implemented HP Polyserve as a Consolidation and as a High Availability Solution for SQL Database Servers.
• Expertise in Installing, building and configuring HP Polyserve Matrix.
• Experience in migrating SQL Server Database Server from Standalone and from Cluster Environments to HP Polyserve Environment.
• Consolidated more than 60 different SQL Database Environments to Polyserve Environment.
• Experience in Building FDA Validated Database Environments.
• Experience in Standing up SAP specific and other Vendor specific Database Servers.
• Experience in Planning and Implementation of security Policies as per PCI and SOX compliances.
• Solid acquaintance with Windows Server, Active Directory, Security Delegation, SPNs and Storage Components.
• Knowledge in a scripting language like Powershell, VBScript, ASP.net and VB.net.
• Experience in 24x7 Production Support, On-Call Support, Escalation Support, Service Restoration Calls.
• Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Excellent Project Management, Analytical, Interpersonal and Communication Skills, Desire to Excel, Fast Learner, Hardworking and Versatile Team Player.

TECHNICAL SKILLS

RDBMS: SQL Server 2014 / SQL Server 2012 / SQL Server 2008R2 / SQL Server 2008/ 2005 / 2000 and 7.0, Oracle 8i/9i /11g, IBM DB2, Teradata and MySQL

SQL Server Tools: Management Studio, Data Tools, BIDS, Profiler, Tuning Advisor, Configuration Tools and Surface Area Configuration.

Reporting and ETL Tools: MS SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

Performance Monitoring Tools: Ignite Confio, Log Parser, Polyserve Performance Dashboard, Windows PerfMon Utility, SQL Server PerfMon utilities and DMVs.

High Availability Solutions: Microsoft Clustering, HP Polyserve Clustering and VMware.

Application and Web Servers: BizTalk Server, Web Sphere, Web Logic, IIS and Apache Web Server.

Languages: T-SQL, Windows Scripting, Power Shell Scripting, C, C++, VB.NET, ASP.NET, Visual Basic, VB Script, JavaScript, XML and HTML.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SQL Server DBA / BI Developer

Responsibilities:

• Responsible for Administrating Production, Development and Test SQL Servers.
• Installed, Configured and Patched SQL Server 2012 in Production, Development and Test Environments.
• Installed and configured SQL Server 2005/2008/2012 with required Service Packs and patches in both Cluster and Standalone environments.
• Performed day to day DB Administrative tasks which includes: DB Performance Monitoring, DB Errors and Alerts Monitoring, Troubleshooting T-SQL Queries, Store Procedures, SQL Jobs,, DTS, SSIS, SSRS, BCP, DBCC, SQL Server Security, Linked Servers and Space management related issues.
• Designed, Developed, Implemented and Automated data pruning task for several business critical databases.
• Developed PowerShell Script as needed for monitoring and administrative purpose.
• Migrated and Upgraded SQL Server Databases from SQL 2005 to SQL 2012 version.
• Migrated and Upgraded SSIS Packages from SQL 2005 to SQL 2012 version.
• Designed, Developed and Deployed many SSIS Packages for business ETL needs.
• Worked on developing SSRS reports against Data Cube by using MDX queries.
• Designed and modified SSAS DataMart Cube as per business requirement.
• Performed POC for Implementing AlwaysOn FCI on SQL 2014 Server
• Performed POC for Implementing AlwaysOn Availability Groups on SQL Server 2014
• Took initiatives to modernize non-standard models, processes, and implementations.
• Implemented database change requests.

Confidential, Columbus, OH

SQL Server DBA/Developer

Responsibilities:

• Responsible for Administrating Production, Development and Test SQL Servers.
• Installed, Configured and Patched SQL Server 2012 in Production, Development and Test Environments.
• Installed and configured SQL Server 2000/ 2005/2008/2012 with required Service Packs and patches in both Cluster and Stand alone environments.
• Prepared the Servers for implementing HADR AlwaysOn Solution by effectively implementing Prerequisites on each replica.
• Implemented High Availability and Disaster Recovery Solution using Failover Cluster Instance.
• Implemented HADR AlwaysOn Solution using Availability Groups on 6 Nodes matrix.
• Configured and Monitored Availability Groups.
• Upgraded and Migrated SQL 2000 \ 2005 \ 2008 Databases to SQL 2012 Environment.
• Implemented Auditing for SQL Databases.
• Responsible for Storage Capacity Planning for SQL Servers.
• Restored Databases using Recovery Advisor.
• Implemented FileTable strategy for efficiently storing the data off of the Databases.
• Performed POC for Implementing Columnstore Indexes.
• Implemented Encryption for SQL Databases.
• Migrated DTS \ SSIS Packages from SQL 2000 \ 2005\ 2008 to SQL 2012 Environment.
• Performed day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management and Resource Utilization.
• Designed and Created databases, tables, Indexes, views, stored procedures and triggers as per requirements.
• Implemented different Replication topologies.
• Responsible for Troubleshooting SQL Serve Performance bottlenecks.
• Responsible for Gathering and Analyzing SQL Server Performance Metrics and providing efficient solution to resolve them.
• Managed SQL Server Analysis Servers, involved in different OLAP deployments.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Installed, Configured and Supported SQL Server Reporting services in SQL 2012 Environment.
• Worked on different SQL Server Reporting Services Projects.
• Served as interface between application and infrastructure teams for Developing requirements, managing demand and monitoring performance.
• Provided technical support to internal developers and external clients.
• Collaborated on the full technical lifecycle from architecture to support of Client Data Environment.

Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2012/ 2008 / 2003 Servers, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, VMware, PowerShell, Cloud Computing, SAN, Avamar Net Backup, Oracle, MySQL, MS BI Dev Studio, IIS, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Frame work and Transact-SQL.

Confidential, Dublin, OH

SQL Server DBA/Developer

Responsibilities:

• Supported SQL Servers in Production, Development and Test Environments.
• Responsible for Managing and administrating more than 690 SQL Servers in Prod\Stage\Dev environments.
• Managed very large databases sized over 5+ TB and server over 8 TB.
• Installed and configured SQL Server 2000/ 2005/2008/2012 with required Service Packs and patches in both Cluster and Stand alone environments.
• Managed clustered environment in Active - Active and Active - Passive environment.
• Build and configured HP Polyserve as a High Availability and Disaster Recovery Solution.
• Consolidated and Migrated SQL DB environments on to PolyServe environment.
• Supported mission critical Enterprise application database.
• Performed day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management and Resource Utilization.
• Implemented High Availability solutions using DB Mirroring, LogShipping, Windows Clustering.
• Performed POC for implementing SQL 2012 HADR.
• Monitored the database objects growth, managed the extents growth and monitored the excessive fragmentation of Indexes and took remedial steps.
• Optimized schema, performance, and capacity planning of various data transformation processes.
• Worked on creating SQL traces using SQL Profiler Wizard and also efficiently used the PerfMon utility and other performance utilities to capture the hardware and performance bottlenecks.
• Responsible for Designing Databases and Database Objects.
• Implemented Log Shipping and Database mirroring between different SQL Instances.
• Implemented various types of Replication Models like Snapshot, Merge and Transactional in 2000/2005/2008 prod environments.
• Managed SQL Server Analysis Servers, involved in different OLAP deployments using MDX queries.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Optimized cubes for better query performance.
• Extracted data from XML files.
• Processed cube to perform incremental updates.
• Migrated SQL 7/ SQL 2000 environments to SQL 2005 / SQL 2008 / SQL 2008 R2 environments.
• Worked on both side by side and in-place SQL Database upgrades.
• Worked with Application teams in converting DTS Packages to SSIS Packages and resolved different package migration issues.
• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL 2005 \ 2008 BIDS and deploy the data; scheduled the jobs to do these tasks periodically.
• Extensively analyzed, maintained and documented complex relational database structures to ensure successful implementation as well as optimal performance.
• Installed and Administered SQL Server Reporting services in SQL 2005, SQL 2008 and SQL 2008 R2 environments.
• Consolidated SSRS environments using Scale-In deployments.
• Designed and Developed reports using SQL Server Reporting Services for DB Administration purposes.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created report snapshots and cache for better performance.
• Worked on different SQL Server Reporting Services Projects.
• Worked with on-shore and offshore teams to provide subject matter expertise.
• Provided technical support to internal developers and external clients.
• Collaborated on the full technical lifecycle from architecture to support of Client Data Environment.

Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2003 Server, Windows Server 2008, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, HP PolyServe, VMware, SAP, Business Objects, Microstrategy,PowerShell, Cloud Computing, SAN, Veritas Net Backup, Avamar Net Backup,, Informatica, DataStage, Oracle, DB2, Teradata, MySQL, Ignite Confio, Tivoli Monitoring tools, Clarify CRM, MS BI Dev Studio, IIS, Weblogic, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Frame work and Transact-SQL.

Confidential, Beverly, MA / Edison, NJ

SQL Server DBA/Developer

Responsibilities:

• Performed periodic maintenance and upgrades on Database Servers.
• Managed all database servers in production, staging, and development and test environments
• Implemented a well-planned backup and restore strategy that protects databases against data loss
• Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of mission-critical operational systems, benchmark establishment, and capacity planning.
• Planned and implemented long-term capacity planning and infrastructure changes to maximize performance for all database components.
• Responsible for deployment and rollback execution to support software/solution releases
• Installed SQL server 2000 \ 2005 on windows 2000 advanced and on Windows 2003 servers, applied service packs and security fixes.
• Successfully Upgraded SQL Server 2000 to SQL Server 2005 in Development, Testing and in Prod Environments.
• Implemented Database Mirroring, logshipping and Replication in Development, Testing and in Prod Environment.
• Developed stored procedures and triggers to retrieve data from the databases to satisfy reporting needs.
• Generated ad-hoc reports using SQL Server Reporting Services.
• Developed DTS and SSIS packages to populate custom data.
• Created custom tables to house data that was not captured in the existing business system's databases.
• Created and Deployed Databases on Advance Reporting Server.
• Installed and Managed SQL Server Reporting Services in different SQL Environments.
• Responsible for Administrating and Troubleshooting Active - Passive clustering networks.
• Responsible for monitoring database performance and network issues.
• Implement logical design into physical design.
• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id’s, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Transformed complex business logic into Database design and maintaining it by using
• SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use
• Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Tuned the Production DB Servers to get the performance improvement by using different performance monitoring tools including SQL Profiler and Index tuning Wizard.
• Responsible for Administrating and Troubleshooting EAI (Enterprise Application Integration).
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Worked with the team in upgrading New Releases of Enterprise Applications.
• Wrote and maintained database documentation, including data standards, procedures, and definitions for logical and physical models of the databases.

Environment: MS SQL Server 2005/2000, Windows 2000 / 2003 Server (32 bit & 64 bit), SSRS,SSIS, MS BI Dev Studio, IIS 6.0, BizTalk, Microsoft .Net Framework 2.0, Excel, Erwin, SQL Tool Belt and Symantec Backup.

Confidential, Kingsville, TX

Software Web Developer

Responsibilities:

• Developed Desktop Application for generating questions from Question bank.
• Involved in Planning, Designing and Testing of Web Application “Online Library”.
• Involved in coding of the Application.
• Involved in Installation, configuration and maintenance of different medical equipments.
• Involved in Planning, Designing and maintaining of Web Application.
• Involved in Deploying of the Application.
• Actively helped Researchers for searching and collecting information on Brown Tree Snakes.
• Involved in time to time modification and updating of Brown Tree Snake web Application.

Environment: Windows XP Professional, Macromedia Dream weaver 8, Macromedia FireWorks, Acrobat Flash8, Java, JSP, JDBC, Struts and MS Access, Visual Basic 6.0, VB.Net, ASP.Net, Content Management System and Web CT.