Sql Server Ms
Resume:
SAGAR GHATTAM MBA
Richardson, TX - ***** • 972-***-**** • ady54f@r.postjobfree.com
** **** ***** ** ** experience in Database Management and Administration. Specializing in design of Logical and Physical construction of data, Data Modeling, Warehousing, Migration strategies of data from legacy systems to current versions of DB2,Oracle,Sybase, MS SQL server and other RDMS servers. Created shell Scripts, Batch scripts, PowerShell scripts.Exception skill in mentoring and building and leading technical teams especially for data quality management and setting up offshore team
Core Skills/Areas of Knowledge
Database Architecture Data Warehousing Data Migration
Database Administration Environment Setup Performance Tuning
Resource Planning Report Authoring Database Programming
Release Management Version Upgrade Code Refactoring
Technical Summary
Microsoft Certified Technology Specialist
Microsoft Certified Infrastructure Provider Microsoft Certified Optimized Solution Provider
Microsoft Certified IT Professional (Database Administrator)
Technical Skills
Databases:
SQLServer 2016/2014/2012/2008/2005, MySQL MS Access, Oracle 8i,9i,10g,11g Sybase 13.xNoSQL,MongoDB
ETL Tools:
BI Stack(SSIS,SSAS,SSRS),Informatica 11,AbInitio,Attunity, Crystal Reports 10, Cognos, Business Objects, Micro Strategy,
Languages:
Java,C++,C#,.NET,T-SQL, PL/SQL,NoSQL
Modelling Tools:
Erwin 3.5.2/4.0, Citrix Win Frame 1.7 DBArtisan Embarcadero
Monitoring and Backup Software
MOM 2005,SCOM 2008,BMC Patrol,,SQL Litespeed,Red Gate 6,Idera Diagnostic manager
Operating System:
UNIX (Aix-3.0), HPUX,SunSolaris13,Red Hat Linux(RHEL 6.5),Windows Server 2000/2003/2008/2012
PROFESSIONAL EXPERIENCE:
Global Payments Inc Plano, TX (Dec'17-Present)
Senior Database Architect
Global payments is Transaction Processing company and is a Global company that acquired Heartland Headquartered in Oklahoma and Business locations in Plano and JVilee.IT has Business critical applications like Passport,Bolletta,Portico,MSB,CPS,Merchant Service application with SQL Server backend that core critical and need 24.7 uptime. The applications have a DR center in Sunnyvale and the enire Shop has its servers running on availability group
As a DBA I managed the entire Development and Reporting environments. I have Built, upgraded and Migrated environments into the latest versions of SQLServer, 2012, 2014 and 2016
Set UP Availability group Cluster in SQL Server 2012 and 2016
Setup Ground work for Moving Databases in Azure in PAAS
Troubleshoot and implement Project plans for long-term resolution for operation and business critical scheduled jobs
Installed and upgraded existing Idera Monitoring Platform and increased the server licensing
Configured Monitoring using Idera Diagnostic Manager for the 2014 and 2016 SQL Servers
Trained off shore support teams on handling Level 1 level escalations
Supported the completed release management process for Merchant applications site in Indiana
Auto generated Monthly Patch analysis, weekly database space utilization and index analysis reports
Environment:SQLServer2012,SQLServer2014,LogicMonitor,IderaDiagnosticManager,QuestAuditior,SSIS and SSRS
North Texas Tollway Authority Plano, TX (May'15- October 2017)
Big Data Architect
I am instrumental in setting up Microsoft PDW a Parallel Datawarehouse Appliance with Symmetric multiprocessing Architecture that is the key component of ELT technology which is a part of Comprehensive Analytics Reporting System Which extracts data from Tolling Source Database in Oracle Exadata and loads it into PDW using Attunity Replicate (Data Loader) which is in turn used for reporting using Micro strategy . I was responsible for implementation of Datawarehouse end to end solution
In my supporting role as a Architect, I am responsible for managing teams that maintain roadway applications built in house and are vendor applications (LoneStar, TER, CCURE) and Payroll applications.
Set up ground work to migrate around 50 applications involving close to 240 databases from SQLServer 2005 /2008 into SQL 2014 and 2016
Tested database objects (stored procs and functions) in Dev and Prod environments in VM ware and Hyper-V Active-Passive clusters (migration from Windows 2003 servers to Windows 2012).
Helped troubleshoot issues with tasks in SSIS package migration from SQL 2008 to SQLServer 2016
Created and distributed a failed daily schedule job report to reduce daily ritual time for all 2014 and 2016 servers .
Configured Monitoring using Idera Diagnostic Manager for the 2014 and 2016 SQL Servers
Migrated Native backup solutions from to EMC Networker Enterprise wide involving Oracle and Microsoft SQLServers with a team of five DBAs
Used Idera SQL Admin tool set to generate comprehensive backup status reports in SQL 2014 and 2016
Auto generated Monthly Patch analysis, weekly database space utilization and index analysis reports
Implemented and Tested always on encryption for finance module in SQLServer 2016 .
Architected a solution for Segregation of Finance and HR portions of PeopleSoft on the backend database servers
Implemented Predictive Analysis solutions for debt recovery department using Tableau 10.0 server with a one developer.
Microsoft
Implemented a migration plan to migrate 60 databases from Oracle 11 g to Microsoft PDW 2016 as part of database consolidation project using custom scripts with database sizes ranging from 120 to 5 TB in size with 3 DBAs
Environment: Microsoft APS 4.0,Attunity Replicate,Microstartegy,Tableau,,SQL Server 2012,SQL Server 2014,Vistal Studio 2013,SSIS (2012&2014),DatManager,Idera,SQL Litespeed and Red Gate,MongoDB 3.0,Oracle 12 g,Exadata, Azure SQLDB
Citigroup Capital Markets Irving, TX (Sep'10- Mar’15)
Lead Arcchitect\Off-shore Manaer
VP ( Infrastructure and BI operations)
As a Lead for Citigroup Global Markets I was instrumental in building production support teams in house, 24/7 Global support hrough teams in EMEA and INdia for several applications for global markets .
Architected migration solution for over 12 Trading floor (PRIMO,SPEED,SPIRIT,EQUITIES,FOREIGN EXCHANGE,PRIME FINANCE,INVESTMENT BANKING,PRIVATE BANKING)
Arcitected BI solution IBD and lead a team to implement it from design stage to Production including setup of ETL jobs, Report Delivery and setting up jobs for Weekly maintenance .
Created a separate team for code refactoring, ITIL process for jobs and report delivery for Sybase, Oracle and SQLServer databases.
I have overseen the following rollouts
• Oversaw migration of large databases into cloud based solutions using SQL Azure for 15 applications
• Architected a Change management process to roll out code for development teams as Part of Change Management process using Service Now and other CA products.
• Architected environments for applications optimizing performance and minimizing resource usage using Hyper-V clusters with a team of three system engineers.
• Setup Knowledgebase site for off shore team from Capacity planning to operations using a team of three
• Optimized backup process through SQL backtrack software and differential backups for PRIMO application this was architected through a team of two DBAs.
Contracted a security team of three Identified vulnerabilities and opportunities for break-ins in the environment.
Improved and managed metrics to help develop analyze driving improvement in all areas of Production Services.
Lead a team of seven DBAs to automate existing operations and procedures, applying best practice guidelines, following enterprise standards and procedures.
Took ownership for escalated issues and implemented right trouble shooting by assigning the right resources
Planned, Installed, designed and supported new and existing software (upgrades) through and auto deploy cycle for downloading and pushing monthly patches.
Served as point of escalation between the client/business area and internal management for the resolution of moderately complex unresolved problems, complaints and service requests.
Created an on call support team that coordinated with various support teams (EMEA, APAC and NAM) across the organization for addressing alerts.
Environment: SQL Azure, MS SQL Server 2012, MS SQL Server 2008, MS SQL Server 2005,Sybase13.x,14.x,15.x SQL Server Reporting Services2008, SQL Server Integration Services, SQL Server Analysis Services, Oracle 10g, Oracle 11 g,Autosys
One Technologies Dallas, TX (May’09- Aug’10)
Lead DataServices (ETL operations)
One Technologies is a technology company with its core business strength in internet marketing. The DBA team supports several teams including Developer team, Data warehouse, QA, Project Managing, Release Management and Customer services along with administering and maintain huge OLTP and OLAP shops. The OLTP Environment consists of data close 1.5 TB and OLAP is close to 3 TB in size. Business drives Technology and IT helps business make decisions through Home grown Business Intelligence solutions
Built OLTP servers from on X64 clustered (Active-Passive environment) and setup Transactional replication for reporting and data warehouse access purposes. Also built all DW servers (OLAP, ETL.Reporting)
Roles and Responsibilities
Lead a team of three that Involved in Day to Day maintenance of Marketing and MCH databases using Transactional replication
Architected and Implemented solutions for ETL Operations (Database monitoring, performance tuning, checking scheduled jobs and observing snapshot behavior for replicated data).
Implemented ITIL methodology with Pre-prod servers simulating Production environment and synchronized through automated refreshes from backups sent through FTP ports.
Architected the upgrade for setting up active passive clustering environment with network load balancing of up to eight servers (with Six Virtual servers).
Lead a team of DBAs to setup instances for Production, Development, QA and UAT environment in SQL Server 2008.
Chalked out strategies for Data conversion to migrate Data from legacy systems to SQL Server.
Implemented a TFS process for deployment of SSIS packages,Cubes and Reports (SQL Server 2008) for weekly release cycle
Lead a team of developers that Upgraded Reports running in SQL Server 2000 through stored procedures to Web based reports in SSRS.
Redesigned OLTP reporting to use database snapshots to be used as a source for reporting for data warehousing.
Implemented a plan to migrate and rebuild packages to the new environment using SSMA
Environment: MS SQL Server 2008, MS SQL Server 2005, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services
BlueCross Blue Shield of Texas Richardson, TX (Nov ’08- Apr’09)
Lead ETL Architect (DB Migrations)
A spun off of Anthem, BCBS currently supports members in Texas,Illinois,Oklahoma and New Mexico
The Enterprise Applications Support Group supports several applications. CVP and Actuarial are two such applications. CVP application Supports 24/7 operations related t automated voice support. Actuarial application determines yearly rates for members.
•Migrated databases from SQL Server 2000 to SQL Server 2005 environment for both CVP and Actuarial environments.
•Involved in Day to Day maintenance of AIS database including database monitoring, performance tuning, checking scheduled jobs and log shipping.
•Set up Disaster Recovery mechanisms depending on the criticality of the data such as Database Mirroring, Replication etc.
•Involved in setting up active passive clustering environment with network load balancing of up to eight servers (with Six Virtual servers).
•Setup instances for Production, Development, QA and UAT environment.
•Created complex stored procedures for Data conversion during migration of Data from Mainframes to SQL Server.
•Upgraded DTS packages (SQL Server 2000) to SSIS packages. (SQL Server 2005)
•Upgraded Reports running in SQL Server 2000 through stored procedures to Web based reports in
•SSRS.
•Created database snapshots and sped up stored procedure execution time through query and performance tuning.
•Migrated and redesigned several packages to the new environment using SQL Server Migration assistant and execute SQL Server 2000 task.
•Created advanced packages in SQL Server using Term Extraction, Term Lookup, fuzzy lookup, fuzzy grouping, and pivot transform, slowly changing dimension transformations
•Involved in scripting using .NET assemblies and designed packages that extract data from heterogeneous sources like XML data, WebServices and Oracle
•Tweaked the package performance using Precedence Constraints, Event Handling, breakpoints,
•Checkpoints and Logging mechanisms for error Handling.
•Involved in architectural design for load balancing using Enterprise Workflows with Control Flow and Enterprise Data processing with data flow designs
Environment: MS SQL Server 2005, MS SQL Server 2000, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services.
Dallas County IT Services Dallas, TX (Jan ’08- Oct’08)
Lead Database Administrator (Contract )
Project Description :
The IT Department supports several large scale and mission critical applications For the county of Dallas. AIS and Odyssey are two such applications. AIS application contains Adult criminal history information. Odyssey application contains court information for civil and criminal cases.
Roles and Responsibilities:
Migrated databases from SQL Server 2000 to SQL Server 2005 environment for both AIS and Odyssey environments.
Involved in Day to Day maintenance of AIS database including database monitoring, performance tuning, checking scheduled jobs and log shipping.
Set up Disaster Recovery mechanisms depending on the criticality of the data such as Database Mirroring, Replication etc.
Involved in setting up active passive clustering environment with network load balancing of up to eight servers (with Six Virtual servers).
Setup instances for Production, Development, QA and UAT environment.
Created complex stored procedures for Data conversion during migration of Data from Mainframes to SQL Server.
Upgraded DTS packages (SQL Server 2000) to SSIS packages. (SQL Server 2005)
Upgraded Reports running in SQL Server 2000 through stored procedures to Web based reports in SSRS.
Created database snapshots and sped up stored procedure execution time through query and performance tuning.
Migrated and redesigned several packages to the new environment using SQL Server Migration assistant and execute SQL Server 2000 task.
Created advanced packages in SQL Server using Term Extraction, Term Lookup, fuzzy lookup, fuzzy grouping, and pivot transform, slowly changing dimension transformations
Tweaked the package performance using Precedence Constraints, Event Handling, breakpoints, Checkpoints and Logging mechanisms for error Handling.
Involved in architectural design for load balancing using Enterprise Workflows with Control Flow and Enterprise Data processing with data flow designs
Environment: MS SQL Server 2005, MS SQL Server 2000, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services.
Professional Development
Professional Development Courses
High Availability Solutions for SQL Server 2012
Master Data and Data Quality Services in SQL Server 2012
Automation of Administration tasks using PowerShell in SQL Server 2008
Microsoft best practices for upgrading SQL Server
Affiliations
Member of North Texas SQL Server Users group.
Active member of Microsoft TechNet user support group
Training
PMP training from Skillsoft
ITIL Process training
Tableau 10 course from DUKE University (Coursera)
Attunity Replicate Training from Attunity
Microstrategy Training certificate from Microstrategy
MongoDB DBA Training certificate from MongoDB University
Microsoft HD Insight Training from Global Knowledge
Data Science Essentials certificate from Microsoft (Through EDX)
EDUCATION
BS in Engineering
MBA in Business Administration (Texas A&M University Commerce (2015))
US Citizen
Texan
Contact this candidate