SUMMARY

• Around 8+ years of IT experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2017,2014,2012, 2008, 2005, 2000 in Production, Test, Development and Replication & Cluster Server Environments.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints
• Worked as both Production DBA and Development DBA.
• Customized TFS Work items and created different work item queries
• Understanding in installing, upgrade, troubleshooting and configuration of MS SQL Server 2000/2005/2008/2012/2014/2017 Database.
• Implemented always on high availability solution in Pre - Production and Production environments.
• Experience working with production and 24 x 7 on call environments and documenting all Database architecture according to established standards.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensive Experience and in-depth working knowledge in various SQL Server tools and IDE to work with database, reporting and business intelligence-based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, and Query Analyzer.
• Excellent Experience in SQL Server administration, replication, database mirroring and log shipping.
• Experience in creating and maintaining SQL Clustering, Optimization, Backup, restore, Security and disaster recovery.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) Packages.
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2008,2010,2012,2014 and 2017 SQL Server Integration Services (SSIS), Import/Export data, Bulk insert and BCP.
• Advanced knowledge and interaction of Microsoft Test Management Configuration Administration
• Generated daily, weekly and monthly reports for the managers.
• Participated in Code review and check-ins of T SQL scripts in Team foundation server(TFS)
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Used regression analysis and forecasting to improve efficiency by 30 percent
• Well versed with reporting packages, databases (SQL, Microsoft Access), programming a plus (XML, JavaScript, or ETL frameworks)
• Proficient in SQL querying (comfort with temporary tables and multi-step queries)
• Proven ability in leveraging data analysis tools and techniques and extracting insights from data and drive resultant business action
• Participated in Release approval meeting.
• Migrated Sql database to Azure platform and worked with devops team on build and release Management.
• Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies.
• Prepared Migration logs for every release and maintained the data accuracy.
• Supported Deployment to all Testing and Production environments.
• Experienced with Star and Snow-flakeD schema dimensional data modeling.
• Proficient in SQL database design, architecture, data modeling using Erwin.
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors and Triggers.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, DMV s, Backup and Recovery.
• Hands on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Organized professional with excellent oral and written communication skills, fast learner and also adapt quickly new technology with ability to take new roles in minimum time and little training. Ability to work individually as well as in a team with excellent problem solving and trouble- shooting capabilities.

TECHNICAL SKILLS

RDBMS/DBMS: Virtual server cloud environment (Azure), MS-SQL Server 2017/2014/2012/2008/2005 Oracle 11i, MS Access, Sybase ASE 12.x, 12.5.x, 15.x

Operating Systems: Windows 2008/2003/2000, NT, UNIX, Linux.

DBA Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Profiler, Idera Tool set, SQL Lite speed, SQL Sentry.

BI Tools: Reporting Service (SSRS) 2017/2014/ 2012/2008/2005, Analysis Services (SSAS),Power BI, azure team foundation server

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Migration Assistant (SSMA)

Programming Language: T-SQL, PL/SQL, C#, .Net and PowerShell

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Administrator/Developer/BI

Responsibilities:

• Configuring the database Servers according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Performed SQL Server cumulative upgrades and Service Pack Upgrades
• Maintained MSSQL databases for several in house and third-party applications.
• Creating Automatic data loading Procedures using PowerShell from the host system to Data Collection Servers
• Using utilities like BCP, ddlgen and Sybase Central.
• Performing basic monitoring tasks on Sybase IQ server
• Security issues related to logins database users and application roles
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like C#, ASP and MS Access, which query the databases. Troubleshooting ODBC and OLEDB issues between the application and the server
• Database Administration and Support of MS SQL Server 201, 2008, 2005 in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Developed korn shell and perl scripts for monitoring Sybase Performance for a new diagnostics application being designed and developed by GE for the purpose of diagnosing the PACS system.
• Developed Korn Shell for the Centricity Doctor Application.
• Designed and developed korn shell scripts for the purpose of monitoring Sybase Server performance.
• Provided automated features in korn shell scripts to monitor Sybase System Vitals.
• Work closely with our BI team to develop our data infrastructure to provide access to information and expand reporting capabilities
• Advanced knowledge and interaction of SharePoint 2013 Site(s) Administration and Team Foundation Server components for SharePoint 2013
• Maintained and monitored routine tasks such as backups, restores, refreshing databases, Re-Indexing, constancy checks, Jobs status.
• Configuring Microsoft SQL server with TFS server.
• Configuring SharePoint foundation services with TFS 2010.
• Configuring SharePoint sites with Team projects in TFS.
• Responsible for the code freeze and stage freeze activities.
• Responsible to push the front-end code to Dev, QA and Stage Pre-PROD environments.
• Worked with automated scripts for Build and Deployment of the applications.
• Responsible for the EBFs Emergency Bug Fixes to push them to different environments and monitor their status.
• Works with senior management team and operation-level managers to design and maintain sales and operations-based metrics. Functions include but not limited to
• Assisted in production of Fixed Income management and decision support reporting and models, with a focus on continuous improvement on process and data
• Assisted in development, roll-out, and maintenance of dashboards, both executive and management reporting, across the enterprise.
• Migrated SQL database to Azure platform and worked with Devops team on build and release Management.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Monitored SQL server Resources like CPU, Memory and Storage Usage.
• Trouble shooting Replication issues and configuring new Publications and Subscriptions.
• Optimized existing replication by modifying agent profiles and agent parameters.
• Working on Managing an Azure SQL Server 2017 environment, including architecture, configuration, replication, backup and management of databases, and code releases.
• Writing Stored Procedures, Triggers, Cursors and creating indexes.
• Successfully Developed Extraction, Transformation and Loading (ETL) process.
• Involved in Rewriting T-SQL code to optimize existing process.
• Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories
• Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
• Worked on VB and C# scripts for inbound and outbound files transfer using SSIS packages
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task .
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• SSAS Administration including configuration, trouble shooting and monitoring processes.
• SSRS Administration including configuration, security management, trouble shooting and monitoring.

Environment: MS SQL Server 2017,2014,2012,2010,2008 SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, Visual Studio 2015,2012, 2010 Sybase ASE, V irtual server cloud environment(Azure), Power BI

Confidential

Sr. Database Administrator

Responsibilities:

• Configured 2 node Active-Active and Active-Passive clusters for production server.
• Analyzing existing application and preparing technical requirements for migration.
• Implemented solutions like always-on, transactional replication and log shipping in both production and non-production environments.
• Responsible for installation, configuration and up gradation of Sybase servers (Upgrade of Sybase server From ASE12.5.2 to)
• Migrating database schema and data using SSMA and SSIS.
• Converting Shell Scripts, Perl Scripts into SSIS packages to perform ETL process for batch loading.
• Created Maintenance standards like Index Reorganization, Tuning, Update Statistics, Maintenance plans etc.
• Converting Sybase and Oracle (PL-SQL) Stored procedures to T-SQL Stored Procedures.
• Modifying VB &Java DAO (Data Access Objects) to point to SQL Server from Sybase and Oracle.
• Deploying JAVA web applications to tomcat server and VB applications in client machines.
• Security issues related to logins database users and application roles and linked Servers.
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like Visual Basic, Java and MS Access, which query the databases. Troubleshooting JDBC and ODBC issues between the application and the server
• Database Administration and Support of MS SQL Server 2008, MS SQL Server 2005 and Oracle in Production, QA, Test, Development.
• Writing Stored Procedures, Triggers, and Cursors and creating indexes.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Reports using Charts, Gauges, Tables, matrix.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.

ENVIRONMENT: MS SQL Server 201, Sybase ASE, SSIS, Microsoft.NET, MS Office Excel, MS Office Access2003,2007, 2013 VBA, Java, Visual Basic 6, Apache Tomcat, BI

Confidential, Jacksonville, FL

Sr. Database Administrator

Responsibilities:

• Designing the database according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Maintained MSSQL databases for several in house and third-party applications.
• Actively involved as part of team for gathering and analyzing the needs of end user requirement and translate these into and technical specifications.
• Installed Sybase ASE 15.0 server on sun Solaris 5.8. Carried out some BCP activities for large tables in order of 400 million rows using views to split data based on datetime colu
• Creating Automatic data loading Procedures from the host system to master systems
• Security issues related to logins database users and application roles and linked Servers.
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like Visual Basic and MS Access, which query the databases. Troubleshooting ODBC and OLEDB issues between the application and the server
• Database Administration, and Support of MS SQL Server 2008, MS SQL Server 2005 and Oracle in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Writing Stored Procedures, Triggers, Cursors and creating indexes.
• Involved in Migration of (Vars Market Risk Data) into Oracle unified schema. This was a merger between Sybase VARS Application database and The CMENT Oracle Database to a Unified Oracle Schema.
• Migrated data across to MSQL 2005 by setting up three main Sybase servers using ASE 12.5.1. Two were installed on Sun Solaris 5.8 and one was set up on Linux Fedora Core 9.8.
• Installed Fedora Core Linux 9.8 also and configured Sybase servers on it too. Such variations were necessary as the dumps were mixed some originated from Sybase on Linux while some from Sun Solaris 5.8.
• Responsible for the maintenance, setup configuration and well being of all Sybase servers, in addition to providing restored data to the end client.
• Upgraded TFS 2010 to TFS 2012 databases and worked with devops team on build and release Management
• Perform upgrade of servers from 12.5.1 to higher ESD to enable the dumps to load successfully.
• Installed Sybase Server with varying sort orders and character sets as well as different page sizes. This was due to the face that data dumps were available in different sort orders and Sybase page size servers.
• Used Microsoft Migration Assistant using (SESMA) to connect to Sybase servers and migrate the data to new created SQL Server databases. There were many applications to migrate to SQL Server each application containing multiple databases.
• Implemented Heterogeneous Replication between Sybase ASE and MS SQL Server 2000 using Direct Connect Gateway, Sybase and Oracle.
• Installation and Maintenance of Sybase Replication Server.
• Successfully Developed Extraction, Transformation and Loading (ETL) process.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services (SSAS)
• Created maintenance plans to process Cubes and to load data into warehouse.
• SSAS Administration including configuration, trouble shooting and monitoring processes.
• SSRS Administration including configuration, security management, trouble shooting and monitoring.

ENVIRONMENT: MS SQL Server 2000,2005,2008,2012, SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, Visual Studio 2010,2012 Sybase ASA,BI

Confidential, Miami, FL

SQL Server Consultant

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing of Data migration project from several legacy databases to newly designed SQL 2008 centralized database repository.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Used Reverse Engineering to create a buffer Data base for Data Migration.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Sybase etc) and loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages to meet business needs.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Designed and developed korn shell scripts for the purpose of monitoring Sybase Server performance.
• Provided automated features in korn shell scripts to monitor Sybase System Vitals. Used Korn Shell scripts to analyze Multiple Sybase Process Block Chains and find out the root process that causes the block chain.
• Converting Sybase and Oracle (PL-SQL) Stored procedures to T-SQL Stored Procedures.
• Modifying VB &Java DAO (Data Access Objects) to point to SQL Server from Sybase and Oracle.Worked on complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Maintaining Sybase stored procedures and Migrating Index calculation for Sybase data
• Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server, some of these tasks included Database integrity checks and re-indexing.
• Created SSIS packages for importing data into staging environment for Cleansing, Parsing, and Scrubbing by using SSIS tools before getting loaded into destination.
• Applied various Data flow and Control flow transformations to meet the business needs.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Designed and deployed Reports with Drop Down menu option and Linked reports
• Developed drill down and drill through reports from multidimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Created subscriptions to provide a daily basis reports and managed and troubleshoot report server related issues.
• Implemented the Transactional Replication for off-loading the OLTP production environment from reporting.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS).
• Created maintenance plans to process Cubes and to load data into warehouse.

ENVIRONMENT: MS SQL Server 2005/2008, SSIS, SSRS, Microsoft.NET, MS Office Access2003, Excel, C#, ASP.Net, VBScript, Erwin, SQL, Crystal Reports, MS Word, MS Excel, MS Power Point, MS Visio, Visual Studio

Confidential

SQL DBA/ Developer

Responsibilities:

• As a SQL Server DBA, provided 24 * 7 missions critical production support of 131 servers including production, test and development servers.
• Installed and configured SQL 2000, SQL Server 2005 on WINDOWS 2000, 2003 servers, applied service packs and security fix.
• Installed, configured and maintained MS SQL fail over clustering for critical production servers.
• Excellent experience configuring and maintaining all three types of replication like transactional snapshot and merge replication.
• Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and test the application after the upgrade, make sure everything is working fine.
• Query Optimization handled by using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005 servers.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created OLAP cubes and dimensions for the analysis of specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2008
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Created the DTS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
• Experienced with creating database maintenance plans for efficient operations.
• Worked with developers to do the database schema changes and database restore requests?
• Involved in restore operations to refresh the data from production to test servers.
• Involved in creating backup strategy production, test and development servers.
• Experience in setting up security features for MS SQL Servers and maintain the user access.
• Document server and database policies and procedures.

Environment: SQL 2008,2005 WINDOWS 2000, 2003, SSRS, SSIS, SSAS, ASP.NET, Crystal Reports 10.0, MS Access.