Sql Server Data
Resume:
Kalyan
Email: *************@*****.***
Current Location: Rancho Cordova, California.
Experience Summary
Five years of experience in Implementation, Administration and Support of MS SQL Server 7.0/2000/2005/2008R2/2012/2014 in Development, Test, UAT and Production Environments.
Installation and configuration of SQL server 2014/2012/2008/2005/2000 with Health Care, Manufacturing and IT sectors.
Specific hands on experience include administering large and complex Databases, Database Design.
Entity relationship diagram (ERD) development / normalization and physical database schema design.
Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.
Good knowledge of MS SQL Server 2008 implementing new features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Performance Data Collector and Transparent Data Encryption.
Created custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version. Experienced in Migrating data between servers (Oracle, MYSQL, Staging, Data warehouse).
Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
Implemented both Active-Active Clustering and Active-Passive Clustering as a disaster recovery solution
Experience in supporting Very Large databases 4TB and troubleshooting the problems.
Experience with 2008 new concepts like Data Auditing, and Policy based management system.
Experience with 2005/2008 concepts like data partitioning, online indexing, DDL triggers, DMV, DMF
Experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity, and experience in migrating SQL Server 2000 to SQL Server 2005/2008/R2/2012/2014.
Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
Thorough knowledge and extensive experience in using .NET Framework Common Language Runtime (CLR) assemblies to create SQL Server objects, such as stored procedures and triggers.
Excelled in generating formatted SQL server Reports by writing parameterized queries using SSRS 2008.
Experience in configure server and client network protocols like SQL Server and SQL Extensions in SQL 2005 using configuration manager.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
Intensive experience in monitoring database performance using SQL Profiler, and the DB’s percent log space for all database servers using SCOM and Windows Performance counters.
Having good knowledge of SQL DBA Bundle from Redgate in performing daily tasks.
Experience in Database Backup, Recovery and Disaster Recovery procedures.
Extensive experience in working with .NET and SQL CLR programming. Created stored procedures, functions, triggers and UDTs (User Define Data Types) in SQL CLR.
Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities
Education
Masters in Software Engineering (RDBMS) from Hartford University, Connecticut, USA.
B.Tech from Jawaharlal Nehru Technological University, Hyderabad, India.
Diploma from SBTET, Hyderabad, India.
Technical Expertise
Databases
MS SQL Server 2000/2005/2008 R2, Oracle 8i/9i/10g, MS Access
Tools/Utilities
SSIS, DTS, SSRS, SQL Server Enterprise Manager, Profiler, SQL Navigator BCP, Query Analyzer, SQL Server Manager, SSMS, Apex log, IDERA, ITSM, ASSURENET, Concur, KRONOS, LOFTWARE, Red gate SQL Compare tool, Database Tuning Advisor, Desk Board, Erwin 7.x, Visual Basic 6.0 & 9.0, ODBC, Excel VBA, ADO, ADO.NET, PL/SQL, TOAD, Visual Studio 2003/2005/2008.
Programming
T-SQL, PL/SQL, C#.net, ASP.net, VB.net, VB Script, HTML, Java Script, Unix Shell.
Ticketing system
ARS, Remedy, Auto Task.
Operating Systems
Windows NT/2000/2003, Windows 9x, HP-UX 10.x, 11.x, AIX 5.3, Solaris 9/10.
Other Tools
MS Office suite 2000/03/10, MS Visio, .Net frame work 1.1/2.0/3.0/3.5/4.0.
Professional Experience
Client: Centene Corporation, Sacramento, CA May16-Present
SQL Server DBA/Developer (Data Analytics)
Description:
Centene Corporation is an American health care insurance provider. HMO, POS, insured PPO and government contracts subsidiaries provide health benefits to approximately 5.9 million individuals in all 50 states and the District of Columbia through group, individual, Medicare, Medicaid, Tricare and Veterans Affairs programs. Centene Corporation offers health insurance plans for individuals and families, groups/companies, and Medicare beneficiaries.
Roles and Responsibilities:
Involved in requirement gathering and analysis of business requirements, participated in requirements review meetings with business users, clients, project management and other teams.
Experienced with Clustering setup and Active Directory in Windows 2010.
Implemented AlwaysOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
Design and develop SSIS packages, store procedures, configuration files, and tables, views, and functions implement best practices to maintain optimal performance.
Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers.
Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
Involved and supported users with ITSM incidents and Change management issues.
Implemented Service Now and Migrated data from ITSM databases to Service Now.
Resolved issues on Concur Travel and expenses configuration issues configured Audit rules and Cognos reports.
Migrated data from Oracle to SQL using SSMA (SQL Server Migration Assistant).
Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
Generated reports by using SSRS and provided them on web server Report manager.
Checked database upgrade advisor for compatibility check for databases before updates.
Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from the developers and non - technical staff member using views.
Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers
Client: Molina HealthCare, Long Beach, CA Nov15–May 16
SQL Server DBA
Description:
Molina Healthcare, a FORTUNE 500, multi-state health care organization, arranges for the delivery of health care services and offers health information management solutions to nearly five million individuals and families who receive their care through Medicaid, Medicare and other government-funded programs in fifteen states. Molina Healthcare owns and operates medical clinics in California, Florida, New Mexico, Virginia and Washington and continues to look for expansion opportunities in member communities. The objective of the QNXT data migration project is to build a comprehensive solution for Order, Sample Management by replacing the legacy order to cash systems with Salesforce.com, Microsoft Dynamics to NetSuite and STARLIMS. This new system solution provides the foundation for GHI to innovate and transform how its patient solutions are delivered and how business operate.
Roles and Responsibilities:
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
Involved and supported users with ITSM incidents and Change management issues.
Implemented Service Now and Migrated data from ITSM databases to Service Now.
Resolved issues on Concur Travel and expenses configuration issues configured Audit rules and Cognos reports.
Migrated data from Oracle to SQL using SSMA (SQL Server Migration Assistant).
Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.
Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability.
Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
Experienced in extracting data from Development / UAT / Production servers by using SSIS.
Used CDC (Change data capture), Table valued parameters and other new features in new applications.
Experienced with Clustering setup and Active Directory in Windows 2010.
Implemented AlwayOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
Develop new processes to facilitate import and normalization, including data file for counter parties.
Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
Created many Cascaded parameters in the reports using MDX and T-SQL.
Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
Supported 24X7 in production issues and User’s issues on applications.
Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2012 / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003
Client: Rodan &Fields, SFO, CA May15 - Nov 15
SQL Server DBA
Description:
Rodan & Fields is a growing Anti-Aging Skin Care company that was founded by world renowned dermatologists from Stanford University. The Project involved migrating the company’s legacy system to a new system and providing production and technical support after the migration due to the company’s expansion into the Canadian market.
Roles & Responsibilities:
Involved in updating existing databases of SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
Design and develop SSIS packages, store procedures, configuration files, and tables, views, and functions implement best practices to maintain optimal performance.
Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
Replicate data from acceptance to QA and production phase.
Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the data warehouse.
Generated reports by using SSRS and provided them on web server Report manager.
Checked database upgrade advisor for compatibility check for databases before updates.
Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from the developers and non - technical staff member using views.
Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
Generated reports by using SSRS and provided them on Share point 2010 Report manager.
Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS OLAP databases. Involved in Tabular Datawarehouse operations for SSAS 2012 and 2008 OLAP databases.
Involved in performing Audits and recovery operations of SSAS objects. Created reports to generate them through Email for the administrative using MDX Queries.
Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Studio 2010,Sybase, MYSQL, Toad, Indexes, LogShiping, .Net Framework 3.5, snapshot, Replication, MS Office suite 2010.
Johnson & Johnson (OCD), Raritan, NJ Jan15 – May 15 SQL Server DBA
Roles and Responsibilities:
Involved in beginning of the project, updated existing database from Oracle Servers to SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
Involved and supported users with ITSM incidents and Change issues.
Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
Involved in the Service Now implementation project.
Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import / export data feeds to / from OLAP data warehouse and claim system.
Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the OLAP data warehouse.
Installed, configured, operated and troubleshot Web SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
Generated reports by using SSRS and provided them on web server Report manager.
Worked with importing flat files and XML files, Share Point, fetched data from other data source like PL SQL, MySQL, and ETL (Extract, Transform and Load) to the database.
Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
Worked with importing flat files and XML files, fetched data from other data source like MS Access, DB2, Mysql, Oracle and ETL (Extract, Transform and Load) to the database using SSIS. Created UNIX shell script to move file across the servers and automation of daily tasks.
Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, Sybase, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Basics, Visual Studio 2008, Indexes, Cluster, .Net Framework 3.5, snapshot, Replication, MS Office suite 2011, Cognos 10.
Virtusa, Hyderabad, India May 11-Dec 13 SQL Server DBA / Developer
Role and Responsibilities:
Involved in new databases design and creation using Rational Rose.
Created Database Diagrams using third party tool ER-Win in beginning of the project. Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
Worked on creation and improving the stored procedures and triggers performance.
Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration.
Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
Created Database Diagrams using third party tool ER-Win in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
Responsible for Query Performance tuning and Optimization.
Created views, SQL joins DTS packages and statements for applications.
Designed and implemented stored procedures and triggers for automating tasks.
Generated T-SQL code for creating cursor and handling the data validations.
Created SQL server Analysis Projects using MS SQL Server 2005.
ETL packages are created to extract, transform and load data to data ware house using SSIS.
Using SSIS the data is transferred to and from flat files, MS Excel, MS Access and SQL Server 2005. .
Implemented the calculations to aggregate physical measures using management studio.
Involved in creation of Multi - Dimensional Cubes and Relational Cubes.
Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.
Developed and maintained MS Access database.
Supported development of a speciation control documents for an MS Access Project Management database
Environment: MS Office suite 2000, MS-SQL Server Management Studio 2000/2005, T-SQL, DTS, Replication, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access, Erwin, SQL Query Analyzer.
Contact this candidate