Data Sql Server
Resume:
PAMPATI PRAVARDHAN
*****************@*****.***
PROFESSIONAL SUMMARY:
* ***** ** ** ********** in SQL Server Administration, Development, and Database Design using MSSQL Server […] environments.
Experience in installing MS SQL Server […] […] and updating with hot fix and service packs.
Expertise in installing and configuring sql server 2012 Always on availability groups
On windows server […]
Hands on experience with High Availability & Disaster Recovery Solutions - Log Shipping, Mirroring (Highsafety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active)
Extensively worked on Active-Active and Active-Passive two node Clustering and three node clustering(Active-Active-passive)
Implemented Side-by-Side and In - Place Migration of MS SQL SERVER 2005 to 2008.Experience in migration of sql server 2008 databases to sql server 2012.
Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.
Good Experience and knowledge in creating and managing user permissions, logins and setting up security according to business standards.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios
Expertise in using DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency Effects, detect CPU, I/O, Memory bottlenecks.
Extensively used repositories like Team Foundation Server (TFS)
Experience in configuring Data Quality Services, (DQS), Master Data Services (MDS) and IIS.
Very Extensively used the native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, index tuning wizard, database tuning advisor for performance analysis
Expertise in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.
Implemented Change data capture (CDC)
Handled Large Databases in Clustered environment using Physical Storage Configuration and SAN Optimization with different RAID Levels.
Experience on Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, DTS, BCP,BULK INSERT etc.
Good knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
Good at SQL Server 2008 new concepts like Policy Based Management, Data Compression, Resource
Governor, Performance Data Collector and Transparent Data Encryption (TDE),
Good knowledge of Data modeling including Physical and logical data modeling using ERWIN, VISIO.
Used Basic power shell scripts.
Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
Knowledge on developing and deploying OLAP cubes through SSAS.
Experience on installing and configuring SSRS on windows environment; also know the process of generating different types of reports.
Hands on experience in working with System Center Operations Manager (SCOM) and Ignite Used third party tools like Lite speed, Red gate, idera diagnostic manager, splunk dashboard, splunkFog light, used pragmatic workbench.
Ability to work independently as well as in a team.
Experience in production support, 24 X 7 on call.
PROFESSIONAL EXPERIENCE:
Zenfolio, Menlo Park, CA Aug 2016 – Present
SQL DBA
Zenfolio is photographer central, all-in-one-photography hosting service, has announced the immediate availability of Photographer Central, the most comprehensive online directory of professional photographers of all genres. By allowing the visual profiles to speak for themselves through a clean, informative interface, potential clients are able to quickly find the perfect photographer according to their location, budget and preferred style.
Responsibilities:
Review, implement and be part of the database design effort: create and maintain databases, schemas, tables, indexes, stored procedures and other objects.
Participate in 24x7 production support, on a rotation basis, of our production databases. Be flexible and available to work shifts that may be outside of standard business hours.
Respond to production alerts in a timely manner and quickly identify, troubleshoot and remediate database issues
Research and suggest solution from small- all the way to platform-scale challenges
Manage and administer for several high-availability production SQL Servers, as well as test and development instances - both physical as well as on the cloud
Analyze the tune database performance; make recommendations relating to performance and efficiency of application SQLs, data storage, query and stored-procedure performance and general processing
Maintain three nines (99.999% / no more than 5 minutes of downtime per year) of production database availability
Establish and maintain backup and recovery procedures of production databases ensuring minimum downtime and maximum recoverability
Support software development process including SQL changes review to ensure optimized released to production and general DBA support for development and QA database environments
Participate in release activities. Assist with deploying DB related changes to Release and production systems
Proactively monitor availability and performance of the production databases
Develop and document appropriate database standards, policies, and procedures to enable standardization, ensure integrity, and promote accountability
Environment: MS SQL Server 2012/2008 R2, VS2015, Sql Azure, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Tortoise SVN, MS Visio, Erwin, Sql Sentry, PRTG and PagerDuty
MIZUHOSI, Union City, CA Oct 2014- July 2016
Tech Lead/ Sr Developer/SQL DBA
Mizuho OSI offers a wide variety of highly specialized surgical tables for spinal, hip replacement, knee replacement and orthopedic trauma surgery as well as the tables for comprehensive imaging required in today’s minimally invasive procedure.
Mizuho OSI is also the nation’s second largest supplier of over-bed traction equipment and offers an extensive line of patient care and pressure management products to hospitals and clinics around the world.
Mizuho OSI products are sold in the U.S. through direct sales representatives and worldwide through authorized international distributors.
Responsibilities:
•Installation and configuration/Maintenance of SQL Server 2012 /2008R2/2008/2005 in all Environments
•Configured and maintained Transactional Replication
•Configured Sql server 2012 always on availability groups with one secondary replica on windows server2008R2/2012.
•Applying sql server patches on all the sql servers
•Database migration from sql server 2008r2 to sql server 2012.
•Worked and involved on database pre-deployment and deployment DBA activities on production servers• Updating the SQL service account passwords prior to expiry on all the servers as per the audit requirement.
•Monitoring all the SQL server alerts like disk space issues and SQL job failures and fixing the issues.
•Configured and maintained Log shipping.
•Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
•Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
•Database Security Maintenance
•Installed sql server 2014 on test servers for testing purpose.
•Created Linked servers accordingly in between the different servers based on the requirement.
•Worked on troubleshooting long running queries, blocking issues and temp db issues
•Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup, check DB and weekly rebuild and scheduling jobs on daily/weekly basis. Monitoring Event Viewer, SQL Error logs for errors.
•Involved in Capacity Planning and adding new storage space as needed
•Responsible for monitoring and making recommendations for performance improvement in databases. This involved index creation, index removal, index modification, and adding scheduled jobs to re-index and update statistics in databases.
•Creating change requests (CRQ'S) for any production changes or implementation.
•Configured Report Server Using Report configuration manager in SQL server 2008R2
•Used IDERA & splunk monitoring tool and upgraded IDERA Diagnostics Manager to the latest version
•Documenting all the issues encountered and all the important activities accomplished in the environment.
•Used Remedy ticketing tool in Resolving database related incidents and requests, resolving incidents within defined SLA's and respond to database related alerts escalations.
•Worked on call 24/7 Support on weekly basis.
Environment: Microsoft SQL Server 2014/ 2012/2008R2/2008, Windows 2008R2/2012 Server, Scom, Idera, splunk, VMware vSphere client, remedy ticketing tool.
RAININ, Oakland, CA Jan 2014- Sep 2014
Team Lead/ MSBI Developer
Rainin is a global manufacturer of scales and analytical instruments. The company consists of several operational divisions in North America and Europe. Rainin specializes in the area of precision instruments for professional use. Rainin laboratory instruments are used in research, scientific, drug discovery and quality control labs, amongst many other in the pharmaceutical, chemical food and cosmetics industries.
Responsibilities:
Involved in installing and migrating legacy databases to SQL Server 2012.
Created Database objects like Tables, Stored Procedures and Triggers in SQL Server 2012.
Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
Created billing components classes in C#, ADO.NET, LINQ and MS SQL
Designed ETL packages dealing with different data sources (SQL Server, Excel Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Used Change Data Capture (CDC) functionality of SQL Server 2012 alongside SSIS to populate the destination tables with inserted updated and deleted data.
Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, and FTP.
Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Used LINQ and ADO.NET for developing data access layer.
Worked with data migration. Used tools like SQL Server integration services (SSIS) in transferring data from one database to another.
Used ADO.NET objects such as Data Reader, Data Adapter and Data Set to object data source fetch and handle user data.
Designed and developed reports using SSRS.
Developed reports using (BID SSRS) depending upon the input parameters required by the business.
Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.
Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.
Worked extensively with the Business Analyst using the Rally to create user stories based on the business requirements.
Provided codes to perform Unit Testing.
Deployment of Application on Test and Production server.
Responsible for maintaining versions of source code using Team Foundation Server.
Managed scrum team of 9 members, assigning tasks and tracking them.
Facilitating Daily scrum meetings, spring planning, spring review, and spring retrospective.
Working with Product owner on Artifacts Such as Product Backlog, Spring Backlog, Sprint Burn down, and Release Burnup.
Managing the overall performance and delivery of cross-functional team
• Publicizing the team's progress and successes to make sure they are highly visible to product owner / stakeholders.
Environment: MS SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MS Access, Oracle 11i
Microsoft Redmond, WA April 2013 – Dec 2013
MS SQL Server Developer/MS Business Intelligence Developer
Microsoft Corporation is an American multinational corporation headquartered in Redmond, Washington, United States that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions. The Project is about analyzing technical issues of Customers of different products and improving the efficiency of providing service using business intelligence solutions. Analyzing the data for improving customer satisfaction and providing security to personal information of the customer is one of the prime criteria of the project.
Responsibilities:
Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
Deploying new Database objects in production environment.
Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
Created different Parameterized Reports (Power BI) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
Create ad-hoc SQL queries for customer reports, executive management reports
Testing and loading the data on Development and Production.
Managing the use of disk space, memory and connections.
Running DBCC consistency checks, and fixing data corruption in application databases
Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
Checked Performance Tuning, Indexing, Query Optimization.
Worked with project manager and technical leads for resolution of technical issues.
Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to help in effective handling of fraudulent activity.
Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which have 3 months’ worth of data which pull data from data warehouse.
Created Indexes, both clustered and non-clustered for improving in performance as the tables contain huge pile of data.
Monitoring jobs to pull huge data into real-time server for analysis purposes.
Attending meeting with clients and upgrading and handling existing reports based on end-user requirements.
Carried out migration to a secure sandbox environment and implementing security levels, encryption and certification on the server to ensure safety to sensitive data.
Created cube for daily calculations of customer feedback based on different attributes and figuring out the satisfaction of customer and time and money spent on handling the call.
Enhanced and developed UI functionality using C#,ADO.Net and HTML.
Created multiple SSIS packages and deployed them to pull in data from 5 different sources regularly and use stored procedures for modifications in data and obtained derived tables to be used in reports.
Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
Added filters, columns, parameters, color coding to existing reports for user –friendliness.
Monitored report manager granting access to end users based on level they need to look data at and providing the end-user with a clean and easily understood user-interface.
Ensure on-time deliveries from Offshore
Environment: MS SQL Server 2014/2012 SQL Integration Services 2012, Microsoft Visual Studio 2012, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.
Dominican University San Rafael, CA Nov 2012 –March 2013
MS SQL Server Developer/MS Business Intelligence Developer
Dominican University of California is a 2,200-student institution in San Rafael, California. Founded in 1890 as Dominican College, Dominican is one of the oldest universities in California.
Responsibilities:
Created a proper data entry system that will collect all the data required in student Information System.
Designed and programmed a method getting data from various external data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements into University Database.
Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
Bulk data migration using SSIS from flat files.
Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS using various features like data conversion etc.
Created derived columns from the present columns for the given requirements.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Responsible for developing a SQL Server Integration Services (SSIS) Framework for Providence Health Plan (PHP) – Dual Framework Phase in Extracts Database.
Generated Custom ETL scripts using SSIS 2005 and develops unit test SSIS load processes for performance check
Enhanced and developed UI functionality using ASP.Net and HTML.
Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
Implemented Micro strategy objects such as attributes, facts, hierarchies and complex metrics that conform to the dimensional and De-normalized data models.
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Developed, monitored and deployed SSIS packages.
Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
Developed different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling.
Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
Used Environment variables to configure the SSIS packages.
Created various reports to analyze the data collected, reconcile with the data imported into student information system, and other reports as determined as necessary.
Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, BizTalk, Oracle 10g/9i.
GEHA, Overland Park, KS April 2012 - Nov 2012
MS SQL Server Developer/MS Business Intelligence Developer
GEHA is the second-largest national health plan and the second-largest national dental plan serving federal employees, federal retirees and their families. GEHA provides health and dental plans to more than 1 million covered lives worldwide.
GEHA is a self-insured and not-for-profit association. Members pay no dues. We currently waive all membership fees. GEHA maintains low overhead costs; of each premium dollar we receive, we return more than 94 cents in direct benefits to our health plan members.
Responsibilities:
Collected business requirements from users and translated them as technical specs and design docs for development.
Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
Bulk data migration using SSIS from flat files.
Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS using various features like data conversion etc.
Created derived columns from the present columns for the given requirements.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
Working on Biz Talk and MS SharePoint
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Developed, monitored and deployed SSIS packages.
Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
Developed different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
Enhanced and developed UI functionality using C#,ASP.Net and HTML.
Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
Developed the packages with monitoring features and logging so that audit information of the
Packages and their execution results are loaded in to the audit table.
Used Team Foundation Server (TFS 2010) to track the changes in code.
Used Environment variables to configure the SSIS packages.
Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, BizTalk, Oracle 10g/9i. Team Foundation Server 2010, Dynamics AX
J. Jill, Quincy, MA May11-April 12
SQL Server BI Developer/C# Developer
J. Jill offers every woman an easy way to dress; one that helps her expresses her own personal style. J. Jill began in 1959 with just one specialty store in the Berkshires has evolved into a thriving cross-channel business with over 200 stores nationwide, more than 26 catalogs a year and an ever-growing JJILL.COM.
Responsibilities:
Involved in installing and migrating legacy databases to SQL Server 2008 R2.
Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
Involved in the development of online order application. It is a website developed using C#, ASP.NET,SQL Server 2008 and SQL CUBE.
Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
Created billing components classes in C#, ADO.NET, LINQ and MS SQL
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Used Change Data Capture (CDC) functionality of SQL Server 2008 R2 alongside SSIS to populate the destination tables with inserted updated and deleted data.
Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, and FTP.
Updated database statistics, Re-indexed and fine-tuned of database objects and server.
Extensively worked on DTA, DMV’s, Online indexing, Data Partitioning and tuning of long running stored procedures and complex queries Designed the data warehouse structure, data modeling and developed it using the Erwin tool, MS Visio.
Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc.
Created multiple reports (SSRS) in Drill mode using tables, financial tables, cross tabs and charts.
Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008 R2.
Performed the Tuning of some existing ETL. The process time was reduced from 8 hours to approx. 6 hours. This was 25% gain in performance
Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
Managing the security of the servers, creating the new logins and users, changing the roles of the users.
Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center.
Clearly communicated defects with developers and updated comments in Mercury Quality center.
Executed the regression test cases along with testing new enhancements by using QTP and analyzed results.
Environment: MS SQL Server 2008 R2/2005, VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MDX, DTS, MS Visio, Erwin
CELCITE MANAGEMENT SOLUTIONS, Herndon, VA Nov 09-April 11
SQL Developer/BI Developer
Calcite Management Solutions delivers optimization solutions for all wireless technologies including GSM/GPRS/EDGE BSS, UTRAN (WCDMA/HSPA +HSUPA PH2) and E-UTRAN (LTE). Founded in 2003, we have enjoyed rapid growth by providing timely and cost-effective wireless consulting services and customized network performance tools to wireless operators worldwide.
Responsibilities:
Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
Implement Type I, II changes in slowly changing dimension tables
Built physical data structures like tables, views, constraints & Indexes
Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volume data.
Implemented SSIS for data transformation logic process.
Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
Designing and building data load procedures, using MS SQL Server.
Configured product meta-data tables to support client data reporting needs.
Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
Working with Different methods of taking Database Backup and Recovery procedures.
Generated database SQL scripts and deployed databases including installation and configuration
Worked on Stored Procedures and Database Triggers.
Worked on large number of business analytical functions.
Working with different types of Replication Models like Snapshot, Merge and Transactional.
Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non
Production database code as well as T-SQL code from developers and QA.
Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
Used Microsoft Source Safe for version control and configuration management.
Tuning the Performance of Database (SQL Profiler), Query Optimization and Application tuning.
Generated various reporting services RDL’S using reporting services for Account Aggregation reports.
Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, DB2, Sybase, Active X, Microsoft Source safe, Windows 2003.
HSBC, Chicago, IL Sep 08–Oct 09
SQL Developer/DBA
HSBC is one of the largest banking and financial services organizations in the world. HSBC's international network comprises around 8,000 offices in 87 countries and in Europe, the Asia-Pacific region, the Americas, the Middle East and Africa. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions.
Responsibilities:
Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
DDL Scripts for generating Tables, Views, Functions.
Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
Scheduling Jobs, Backups and Restore database
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Performance tuning, query optimization and execution plan of queries for better performance.
Configured IIS and Deployed Reports and Analysis Project in to server.
Extended Data to XML and Excel Spread Sheet.
Developed reports using SSRS 2005 and Crystal reports, used table control, matrix control forcross tab reports.
Contact this candidate