­

PROFESSIONAL SUMMARY:

• 11+ years of experience in analyzing, designing, administer, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2014/2012/ 2008/2005/2000 , DTS/SSIS, and Reporting & Analysis Services. .
• Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, administer, coding, testing, and debugging new and existing client - server based applications).
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin
• Implemented and provisioned AWS services combining hands on experience with services like EC
• Familiar with Data Warehousing designs in Star and Snow flake Schemas.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Experience in establish and maintaining the Databases, Database design and implementation, Database tuning, Performance monitoring and Review Error Logs, Storage capacity on server drives, backup/restore databases on various environments such as Development Server, Test Server, Staging Server and Production Server
• Expertise in configuring, implementing and monitoring different types of High Availability and Disaster Recovery including Replication (Snapshot and Transactional), Log Shipping, Database Mirroring.
• Worked in Active-Active, Active -Passive Cluster environment as a High availability solution.
• Implementing high availability with Always-On Availability Groups and failover clustering
• Upgrading SSIS Packages, SSRS Reports and Databases from SQL Server 2005/2008 Version to SQL Server 2012 & 2014
• Skilled in SQL Business Intelligence tools, Data Warehousing and strategies using SQL server Analysis and Integration Services.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008/2005
• Extensive Experience in using the Cube Components like KPIs, Calculations, Perspectives and Partitions.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Ability to define and develop Report Structure with data definition, report layout and report definition language
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart Report, Pie charts & column report. Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Expertise in database optimization using tools like Database engine Tuning Advisor, SQL profiler, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem-solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

SKILLS:

MS-SQL Server 2016/ 2014/2012/ 2008/2005/2000 /7.0,VS2013/2010, Oracle 8i/9i/10g, Toad, MS Office, T-SQL, PL/SQL, C, C++, C#, HTML, XML, Java ASP .NET, VB .NET, Windows 98/2000/2003/ XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server, MS SQL Server Reporting Services 2008/2005/2000 (SSRS), MS SQL Server Analysis Services 2008/2005(SSAS), MS SQL Server Integration Services 2014/2012/ 2008/2005/2000 (SSIS), Data Transformation Services (DTS), ODBC, SQL Server Management studio (SSMS), Erwin 7.2/7.1/4.1 MS Visio 2007/2003, BCP, Active Directory, RS Utility

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL DBA Lead

Responsibilities:

• Managing a team of Database Administrators and delegate the responsibilities.
• Installation and managing SQL Server 2016, 2014, 2012, 2008R2, 2008 on different environments.
• Worked on creating, managing SQL Server Databases and setting up Connection Strings and connecting SQL Server Databases from locally installed SQL Server Management Studio (SSMS) for Developers
• Worked on designing and implementing Always On for database environment to make sure we have 99.99% uptime and 24/7 High availability of as part of the DR implementation.
• Involved in Data center Migration project for moving databases across the location which includes servers with SQL Server 2008 to SQL Server 2012, 2014, & 2016.
• Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment.
• Installed the application on AWS EC2 AMI, Red hat, Ubuntu Instances.
• Implemented AWS solutions using E2C, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling group
• Implemented backup strategy for the new data center environment.
• Daily support, troubleshooting, monitoring, optimization and tuning of SQL server environments across entire system.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Working with ServiceNow Tickets (Any changes on Production, staging and development environment need to Create ServiceNow Tickets).
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
• Installed and managed SSIS, SSAS and SSRS services on different environments.
• Developed SSRS reports for the internal reporting dashboard.
• Managed SSAS cubes and supported full, incremental load process.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Created Database Diagram using Erwin Data Modeler, Data Dictionary Document, Database Installation and Configuration Document and Merge Replication Setup Document.
• Integrated different database environments like Sybase SQL Server,DB2, Oracle SQL Server etc.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.

Confidential, Cleveland, OH

Senior Database Administrator

Responsibilities:

• Involved in T-SQL Coding using Temporary Tables, CTE’s, Cursor and also Insert Update Commands to Update the Target Tables of the Database and Views to reduce database complexities.
• Upgrading SSIS Packages, SSRS Reports and Databases from SQL Server 2005/2008 Version to SQL Server 2012 & 2014
• Take care of the Database design and implementation, Database tuning, Performance monitoring and Review Error Logs.
• Establish and maintain the databases, storage capacity on server drives, taking backup of databases, restore databases on various environments such as Development Server, QA (Test) Server and Staging Server.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Set up and monitored Database Mirroring on Production, Test and Development servers and troubleshoot the errors.
• Worked in Active-Active Cluster environment as a High availability solution.
• Worked on setting up Transactional Replication (Push and Pull) and Merge Replication.
• Checking Database Health by using DBCC Commands
• Implementing high availability with Always-On Availability Groups and failover clustering
• Developed ETL Processes using SQL Server 2008/2005 Integration Services (SSIS) to migrate the data from various sources as per project requirement
• Developed batch files in order to run the SSIS Packages in order of which one to run first and then the later one and also set up the environment needed for those batch files to run properly.
• Provide Instructions, development support for maintenance release, Updated Versions, patches as DBA and worked with development team for migration of data from various sources of the projects
• Working Knowledge of Crystal Reports
• Upgraded / Migrated SQL Server reporting services
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads in order to understand the business requirements in more elaborated manner.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, SQL Query Analyzer in MS SQL Server, Execution Plans, Index Tuning Wizard, and Database Engine Tuning Advisor.
• Documented all the Phases Involved in the project and Documented process to document procedures, priority lists, escalation lists, production changes and roll out procedures.

Confidential, Cleveland, OH

Database Administrator (DBA) / Sr. Database Consultant

Responsibilities:

• Take care of the Database design and implementation, Database tuning, Performance monitoring and Review Error Logs.
• Establish and maintain the databases, storage capacity on server drives, taking backup of databases, restore databases on various environments such as Development Server, QA (Test) Server and Staging Server.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Set up and monitored Database Mirroring on Production, Test and Development servers and troubleshoot the errors.
• Worked in Active-Active Cluster environment as a High availability solution.
• Worked on setting up Transactional Replication (Push and Pull) and Merge Replication.
• Checking Database Health by using DBCC Commands
• Implementing high availability with Always-On Availability Groups and failover clustering
• Developed ETL Processes using SQL Server 2008/2005 Integration Services (SSIS) to migrate the data from various sources as per project requirement
• Developed batch files in order to run the SSIS Packages in order of which one to run first and then the later one and also set up the environment needed for those batch files to run properly.
• Developed number of Iterative Builds related to different projects by comparing the T SQL Scripts, Functions, Stored Procedures and Tables.
• Provide Instructions, development support for maintenance release, Updated Versions, patches as DBA and worked with development team for migration of data from various sources of the projects
• Upgrading SSIS Packages, SSRS Reports and Databases from SQL Server 2005/2008 Version to SQL Server 2012 & 2014

Confidential, Cleveland, OH

Database Administrator (DBA) / Sr. SQL BI Developer

Responsibilities:

• Created & Modified Number of Stored Procedures, Tables as per constraints.
• Involved in T-SQL Coding using Temporary Tables, CTE’s, Cursor and also Insert Update Commands to Update the Target Tables of the Database and Views to reduce database complexities.
• Take care of the Database design and implementation, Database tuning, Performance monitoring and Review Error Logs.
• Establish and maintain the databases, storage capacity on server drives, taking backup of databases, restore databases on various environments such as Development Server, QA (Test) Server and Staging Server.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Set up and monitored Database Mirroring on Production, Test and Development servers and troubleshoot the errors.
• Worked in Active-Active Cluster environment as a High availability solution.
• Worked on setting up Transactional Replication (Push and Pull) and Merge Replication.
• Checking Database Health by using DBCC Commands
• Implementing high availability with Always-On Availability Groups and failover clustering
• Developed ETL Processes using SQL Server 2008/2005 Integration Services (SSIS) to migrate the data from various sources as per project requirement
• Developed batch files in order to run the SSIS Packages in order of which one to run first and then the later one and also set up the environment needed for those batch files to run properly.
• Developed number of Iterative Builds related to different projects by comparing the T SQL Scripts, Functions, Stored Procedures and Tables.
• Provide Instructions, development support for maintenance release, Updated Versions, patches as DBA and worked with development team for migration of data from various sources of the projects

Confidential, Honolulu, HI

Database Administrator (DBA) / Sr.MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created & modified a number of Stored Procedures based on the Normalization and Constraints of the Associated Tables.
• Created Custom Tables in Order to provide the Interface between the Source Tables and the Target Tables and gives the Custom Generated Messages based on the constraints provided which will help the Target Database Tables to get the data in refined manner.
• Involved in Huge amount of Coding using Temporary Tables, CTE’s, Cursor, and also Insert Update Commands to Update the Target Tables of the Database and Views to reduce database complexities.
• Developed ETL Processes using SQL Server 2008 Integration Services to migrate data of Large Number of Tables from SQL Server to SQL Server and Also to Excel Files.
• Developed the ETL Processes Using the Tasks Like File System Task, Execute SQL Task, Script Task.
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Sort, Union all, Conditional Split, Merge join and more) and huge XLS file is created which have the Overall Data Involved with Different Input and Target Tables.
• Involved in Creating Variables, Manifest Files, Logging Files (Log to SQL Server DB and Windows Event Logs) and also to create the dtsConfig File using Package Configurations.
• Setup Test, Dev, Staging and Production Environments.
• Create Users and assign permissions based on the level of database access the user would need.
• Maintain the database security, its performance, space allocation, database integrity check and planning the future changes or workloads
• Created and scheduled Backup jobs, index maintenance jobs, consistency checks and update statistics.
• Used Log Shipping for synchronization of database.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Created sub-reports, drilldown-reports, parameterized reports in SSRS.
• Created standard & Data driven report subscriptions. Also Created report snapshots and cache for better performance.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and SQL Query Analyzer in MS SQL Server 2008.
• Unit Tested All of the Stored Procedures and Queries in order to get the Right Matching Results
• Documented all the Phases Involved in the project and also the Stored Procedures and Scripts for future references.

Confidential, Newark, DE

Database Administrator (DBA) /Sr. MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed ETL Processes using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database
• Created SSIS Packages by using different kinds of transformations (i.e. pivot Transformation, Derived Columns, Conditional Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Created and scheduled Backup jobs, index maintenance jobs, consistency checks and update statistics.
• Involved in Installing SQL Server 2008 and creating users and Groups.
• Created & modified a number of existing stored procedures based on the changes made to some existing tables.
• Establish and maintain sound backup and recovery policies and procedures. Establishing the needs of users and monitoring user access and security
• Work as part of a team and provide 7×24 supports when required.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SQL Server 2008 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard & Data driven report subscriptions. Created report snapshots and cache for better performance.
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Do general technical troubleshooting and give consultation to development teams.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Confidential, Burlington, Massachusetts

Database Administrator (DBA) / MS SQL Server /SSIS/ SSRS Developer

Responsibilities:

• Responsible for creating logical and physical model using Erwin Data Modeler.
• Created reports from prototype Analysis Services Cube using SQL Server 2008Reporting Services.
• Extracted data from SharePoint Server to build SSIS packages.
• Created report snapshots and cache for better performance. Created standard & Data driven report subscriptions.
• Establish and maintaining the Databases, Database design and implementation, Database tuning, Performance monitoring and Review Error Logs, Storage capacity on server drives, backup/restore databases on various environments such as Development Server, Test Server and Staging Server
• Developed SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Worked on database Design and Architecture based on business user requirements and performed Normalization (3NF) and De-Normalization
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated ad hoc reports using MS Reporting services.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Involved in documentation for all kinds of SSRS report and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.

Confidential, Baton Rouge, LA

Database Administrator (DBA) /SQL Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the new system.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Successfully migrated data from Microsoft SQL Server 2000 to Microsoft SQL Server 2005 using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Experience in Programming OLAP advanced objects like KPI ’s and Perspectives.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs using SQL Server Analysis Services (SSAS ) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed and designed cubes with dimensions, Measures and calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI .

Confidential, San Mateo, California

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Extracted required mapping fields from different sources to Warehouse for Staging Table.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales which is available in Central Data Warehouse (CDW) for migrating the data.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from CDW.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and Cleansing the Standardized Data by using transformations in Data Flow Task (i.e. Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Data Warehouse from different data sources and other ongoing tasks for mapping.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like pdf., excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Documented all old and migrated Store Procedures and scripts for future references.