Sql Server Database Administrator

Curriculum Vitae of Anitha PT Page * of *

Anitha Telkar

***** ** **** **, ******** WA 98005 Ph.: 425-***-****, Email: ********@*****.*** Objective: Enthusiastic Senior SQL Server Database Administrator with strong Development and BI experience – Looking for a Full-time Opportunity. SUMMARY AND ACCOMPLISHMENTS

Over 15+ years of experience in SQL Server DevOps/Database Administration/Architecture for SQL Clustering and Azure High Availability with very large and complex Production Servers databases in SQL Server 2019/2017/2016/2014/2012/2008 R2, 2008/ 2005 and 2000 with Performance Tuning and Maintenance with Outstanding Troubleshooting capabilities.

Strong Experience with TSQL language, writing and optimizing stored procedures having very good of knowledge of software development life cycle (SDLC) with substantial experience with object-oriented analysis and design & architecting methodologies. Possess experience in independently handling design, development, documentation, and testing phases in a project environment.

Extensive experience in migration of database from On-Prem to Azure/AWS using different methods.

Created SSIS Packages to extract data from various sources to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to enterprise databases.

Performing routine Data Imports, Backup & Restore, SQL Agent Jobs, and Data Modeling/Architecture of databases that can only be performed using bulk load or build updates.

Developed and maintained SSIS/ETL (Data Extraction, Transformation and Loading) to extract the data from multiple source systems that comprise databases like Oracle 10g, Oracle 11g MongoDB, PostgreSQL SQL Server 7.2, flat files to the Staging area, and then to the Data Marts.

Expertise in supporting Very Large Databases (VLDB)/LOB XML Data with around 300 TB and troubleshooting issues.

Expertise in troubleshooting performance problems, fine-tuning of databases and index Analysis using tools like Extended Tools, Data Collector MDW (Management Data Warehouse), Profiler, Extended Events, Performance Monitor, and including DMV’s.

Extensive troubleshooting skills on SQL issues in proactive and reactive SQL Server Problem Engineering by using SQL Tools, execution plans, Trace, statistics, created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

Extensively worked on Design and support high availability solutions using SQL Server Log Shipping, SQL Server Mirroring, SQL Server Replication and SQL Server Always On Technologies with Azure High Availability.

Strong experience in mentoring team members with design and architecture with very large and complex Production Servers databases /disaster recovery solutions and writing documentation.

Worked on 24 X 7 X 365 Production Database on Call Support.

Thorough knowledge on scripting languages like Batch scripting, VB Scripting, PowerShell. Technical Skills

Operating System: Windows 2012, Windows 2008, Windows XP, Windows NT Database: SQL Server(2005 – 2022), SSRS, SSIS, SSAS, Oracle, NoSQL, MongoDB, PostgreSQL

Curriculum Vitae of Anitha PT Page 2 of 8

Tools: Perfmon, Extended Events, MDW, Diagnostic Manager, SQL Sentry, Solar Winds, DMA, DMS

Languages: C#. NET, VB.NET, ASP.NET, TSQL, ASP, XML. Reports: SSRS, Crystal Reports

Cloud: SQL Azure, AWS RDS

Version Control: GitHub, MS Visual Studio, Visual Source Safe, CVS Scripts: PowerShell Scripts, Batch Scripts, VB Scripts Professional Experience:

Lead SQL DBA Wizards of the Coast November 2021 – Current Hybrid Currently working as a Lead SQL DBA on various gaming platforms, on an Enterprise Level support and administration focused explicitly on SQL Server 2019 Performance and Optimization tuning, SQL Migration.

• Extensive working experience in mentoring, administering, monitoring and troubleshooting mission critical OLTP systems for the DBA team.

• Extensive work experience and monitored support staff to ensure in migrating the data from SQL Server 2012/2008 / 2005 to SQL Server 2012/2014/2016/2017/2019/2022.

• Extensive work experience and monitored support staff to ensure in migrating the data from On-Prem SQL Server 2012/2008 / 2005 to SQL Server 2012/2014/2016/2017/2019 to AWS or Azure SQL Server with Azure IaaS and /or PaaS, system design, implementation and operational support.

• Extensively led the team to Design and support high availability solutions using SQL Server Always On Technologies and with SQL Clustering and Azure High Availability. Extensively worked on data design architecture and support high availability solutions using SQL Server Always On Technologies and have strong experience in migrating various SQL Server DB’s

• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

• Experience in Disaster Recovery Planning and Security Management operations.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Lead SQL Server DBA Kroger November 2020 – October 2021 Working as, a Senior SQL Server DBA in the Kroger as a part of SQL of Payment Systems and Pricing Cloud team helping to manage resolving tickets, migration of database from on-prem to hybrid cloud, table partitioning, maintenance of jobs including computer systems, storage systems, designing, maintaining, monitoring, and troubleshooting the SQL Server databases for its leveraging global technology capabilities.

• Extensive working experience in mentoring administering, monitoring and troubleshooting mission critical OLTP systems for the DBA team,ensured tasks are assigned to team members based on priority and due dates on Service-Now ticketing system.

• Extensively worked and led the team in getting automation of partitioning the tables integration monitoring and configuration management.

• Expertise in developing data architecture, database schemas for Relational database objects, models and DB designs/systems including creating SSIS/SSRS packages using Azure Data Factory on Prem and Azure and AWS.

• Migrated many prem databases like SQL Server, Oracle to Azure SQL Server.

• Focused on migrating the data from SQL Server 2012/2008 / 2005 to SQL Server 2012/2014/2016/2017/2019/2022.

Curriculum Vitae of Anitha PT Page 3 of 8

• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

• Extensively worked on Design and support high availability solutions using SQL Server Always On Technologies and with SQL Clustering and Azure High Availability.

• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

• Experience in Disaster Recovery Planning and Security Management operations.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

• Expertise in capacity management managing /advice developers on best practices, review code and implement changes into development and production environments

• Troubleshoot performance problems, fine-tuning of databases and index Analysis.

• Streamlined applications delivery to get applications out to customers faster. Lead SQL DBA Bemis /Amcor February 2019 – October 2020 Worked as, a Senior SQL Server DBA in the Bemis / Amcor through TCS as a part of SQL team helping to manage resolving tickets, migration of database from on-prem to cloud, table partitioning, maintenance of jobs including computer systems, storage systems, designing, maintaining, monitoring, and troubleshooting the SQL Server databases for its leveraging global technology capabilities.

• Focused on automation integration monitoring and configuration management.

• Expertise in creating database schemas for Relational database objects, models, and DB designs/systems.

• Focused on migrating the data from SQL Server 2012/2008 / 2005 to SQL Server 2012/2014/2016/2017/2019.

• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

• Extensively worked on Design and support high availability solutions using SQL Server Always On Technologies and with SQL Clustering and Azure High Availability.

• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

• Experience in Disaster Recovery Planning and Security Management operations.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

• Migrated many on prem database like SQL Server, Oracle to Azure SQL Server.

• Expertise in managing /advice developers on best practices, review code and implement changes into development and production environments

• Troubleshoot performance problems, fine-tuning of databases and index Analysis.

• Streamlined applications delivery to get applications out to customers faster.

• Experience in working on Service-Now ticketing system. Senior SQL DBA Boeing June 2018 – January 2019 Seattle, WA Worked as, a Senior SQL Server DBA in the Boeing through TCS as a part of SQL team helping to manage resolving tickets, migration of data, maintenance of jobs.

• Focused on automation integration monitoring and configuration management.

• Expertise in creating database schemas for Relational database objects, models and DB designs/systems.

Curriculum Vitae of Anitha PT Page 4 of 8

• Focused on migrating the data from SQL Server 2012/2008 / 2005 to SQL Server 2012/2014/2016/2017.

• Extensively worked on Design and support high availability solutions using SQL Server Always On Technologies and with SQL Clustering and Azure High Availability.

• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

• Experience in Disaster Recovery Planning and Security Management operations.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

• Migrated many on prem database like SQL Server, Oracle to Azure SQL Server.

• Troubleshoot performance problems, fine-tuning of databases and index Analysis.

• Streamlined applications delivery to get applications out to customers faster.

• Utilized SQL database systems.

• Relied on solid systems network stack experience. Senior SQL DBA DTI Global May 2017 – Nov 2017 Seattle, WA Currently working as a Senior SQL Server DBA in DTI Global as a part of SQL team helping to manage resolving tickets, migration of data, maintenance of jobs.

• Focused on migrating the data from SQL Server 2012/2008 / 2005 to SQL Server 2012/2014/2016.

• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

• Extensively worked on Design and support high availability solutions using SQL Server Always On Technologies and with SQL Clustering and Azure High Availability.

• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

• Experience in Disaster Recovery Planning and Security Management operations.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

• Troubleshoot performance problems, fine-tuning of databases and index Analysis. Lead Senior SQL DBA Microsoft January 2016 to June 2016 Redmond, WA Worked as, a Lead Senior SQL Server DBA/DevOps in the Microsoft Cloud and Enterprise group. Develop, package, migration of database from on-prem to cloud, table partitioning, and deploy powerful applications and services to the cloud with Azure Cloud Services and the click of a button.

• Focused on automation integration monitoring and configuration management.

• Expertise in creating database schemas for Relational database objects, models and DB designs/systems.

• Expertise in creating database schemas for Relational database objects, models and DB designs/systems including creating SSIS/SSRS packages using Azure Data Factory on Prem and Azure and AWS.

•

• Extensively worked on Design, migration of database from on-prem to cloud and support for SQL Clustering and Azure High Availability solutions using SQL Server Always On Technologies.

Curriculum Vitae of Anitha PT Page 5 of 8

• Created SSIS Packages to extract data from Excel files, MS Access files using Pivot Transformation, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to enterprise databases.

• Streamlined applications delivery to get applications out to customers faster.

• Utilized SQL database systems.

• Relied on solid systems network stack experience. Lead Senior SQL DBA IBM March 2015 to December 2015 Redmond, WA Worked as, a Lead Senior SQL Server DBA/DevOps for a team of 3 DBA’s and IIS administrator for IBM to manage Kaiser Permanente's data center operations, including computer systems, storage systems, designing, maintaining, monitoring, and troubleshooting the SQL Server databases for its leveraging global technology capabilities.

Expertise in managing /advice developers on best practices, review code and implement changes into development and production environments.

• Expertise in creating database schemas for Relational database objects, models, and DB designs/systems.

• Developed and maintained ETL (Data Extraction, Transformation and Loading) to extract the data from multiple source systems that comprise databases like Oracle 10g, NoSQL, SQL Server 7.2, flat files to the Staging area, and then to the Data Marts.

• Expertise in Performance Tuning using Extended Events for 2008 and 2012 SQL, Data Collector and MDW, Profiler, Service Broker, DMV’s and Windows Performance Monitor.

• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert with Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g/DB2. Also created DTS package for data transfer between the two environments.

• Extensively worked on Design and support high availability solutions using SQL Server Log Shipping, SQL Server Mirroring, SQL Server Replication and SQL Server Always On Technologies.

Senior SQL DBA Microsoft, Redmond, WA March 2012 to March 2015 Worked as a Senior SQL Server SQL Server DBA/DevOps for Microsoft Products and Services IT

(MPSIT) team within Microsoft IT. Responsible for providing extensive SQL Enterprise Solutions across MPSIT on many critical applications on a daily basis to ensure service-related issues are identified and resolved within established SLAs.

• Administered and responsible for all production, pre-production SQL Servers and related systems for giving database support, troubleshooting, planning and migration for MPSIT.

• Provided and implemented extensive workarounds on SQL bugs on the LOB XML data, blocking, Subscription Streams parameter and various issues related to Replication Latency issues and other problem engineering issues.

• Expertise in Performance Tuning using Extended Events for 2008 and 2012 SQL, Data Collector and MDW, Profiler, Service Broker, DMVs, and Windows Performance Monitor.

• Extensively worked on Design, migration of data from on-prem to cloud and support for AZURE High Availability solutions using SQL Server Always On Technologies.

• Expertise in Configuring Data Collector Management Data Warehouse (MDW) for performance monitoring on multiple instances configured to a single central instance for detailed reporting.

• Created SSIS Packages to extract data from Excel files, MS Access files using Pivot Transformation, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MA Access, and CSV files to enterprise databases.

• Design and Configured Transactional Replication, Log Shipping and SQL Mirroring Curriculum Vitae of Anitha PT Page 6 of 8

• Extensive troubleshooting skills on problem engineering issues like deadlocks, tracing long running queries, data compression, Service Broker, and various other technologies like SQL Clustering and Azure High Availability Always On, Log Shipping, Mirroring and Replication.

• Configured Database mail, linked servers in SQL server 2008 and SQL server 2012.

• Created and worked on various support related reporting tools of using SSRS (SQL Server Reporting Services) for the operations use for Subject Matter Expertise. Senior SQL DBA T-Mobile, Bellevue, WA Dec 2011 to February 2012 Smart Mart is the original postpaid operational data warehouse loaded on a daily, monthly and weekly basis tracking for Activations, Deactivations, Reactivations, Base, Contract Renewals, and Migrations.

• Expertise in troubleshooting and performing routine Data Imports, Backup & Restore, Log Shipping, and Mirroring of databases SmartArt database functionalities that can only be performed using bulk load or build updates.

• Used the Remedy to track and analyze open defects found during the Design.

• Manage tickets and work on it to ensure production is left with no issue. Involved in design, review specifications meetings as required.

• Expert in Performance Tuning analyzed long running queries and tuned them to optimize the system performance.

• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.

• Expertise in pulling the production reports from OLTP systems into OLAP databases Senior DBA AT&T, Bothell, WA Dec 2009 to Nov 2011

Fusion Works Balance Manager is a Web service application for Session based Pricing solution for AT&T enabling the end-to-end order, fulfillment, provisioning, real-time session usage collection, metering, rating/charging, management /control, and notifications for wireless broadband limited PREPAID data plans with policy control of bandwidth and overage charging and throttling.

• Expertise in writing complex database queries, Stored Procedures, Triggers, SQL Cursors using joins with multiple databases database designs and relational database concepts and identify Data Integrity issues by SQL queries.

• Performing routine Data Imports, Backup & Restore, SQL Agent Jobs, and Data Modeling/Architecture of databases Mediation database functionalities that can only be performed using bulk load or build updates.

• Used the Quality Center Defect Manager System to track and analyze open defects found during the Design.

• Responsible for testing of AT&T Balance Manager Web Service Application.

• Expertise in troubleshooting and performing routine performance tuning and troubleshooting issues on Log Shipping, and Mirroring of databases SBP Balance Manager

• Manage tickets and work on it to ensure production is left with no issue. Senior SQL DBA Microsoft, Redmond, WA June 2005 to September 2009

• Expertise in supporting Very Large Databases (VLDB)/LOB Data with more than 30 TB and troubleshooting the problems.

• Involved in troubleshooting and performing routine Data Imports, Backup & Restore, and Log Shipping of databases for AdCenter Analytics (ACA) Behavioral Targeting (BT) functionalities that can only be performed using bulk load or build updates.

• Strong process background in change control, source control, backup strategies.

• Identify Data Integrity issues by SQL queries and correct them.

• Remove data anomalies in Inter World Product catalog data by importing the data into Microsoft Excel.

SQL Developer/SQL DBA Chem Point, Bellevue, WA Jan 2004 to Sep 2004 Curriculum Vitae of Anitha PT Page 7 of 8

Dimensional Data Warehouse is an e-business model designed to complement and build upon the strengths of traditional chemical distribution making the specialty chemical sourcing experience faster, easier - while retaining the customer service and personal touch. I was involved in identifying Data Integrity issues using T-SQL, VBA and remove data anomalies in the application product.

• Identify Data Integrity issues by SQL queries and correct them.

• Data analysis & validation using Microsoft Excel & VBA programs.

• Remove data anomalies in Inter World Product catalog data by importing the data into Microsoft Excel.

SQL Developer/SQL DBA Eros Pharma Ltd., Bangalore, India Jul 1999 to Aug 2000 The aim of the project Eros Web is to simplify the process of Data entry by company officials from different parts of the country into their respective tables. This involves daily visits, Tour Program, Expenses, Mails and various reports. This project involves various security features to prevent unauthorized entry for the pages that are exclusively for the company people and again only to the allowed areas of the application depending on their privileges. SQL Developer/SQL DBA IIQ Systems. Bangalore, India Jul 1997 to Jul 1999, India E_PEOPLE is the on-line recruitment product. Considering the requirements of staffing companies. At the same time the requirements of Job Seeker & Job Provider also considered. SQL Developer/SQL DB SCOT systems, Bangalore, India Jan 1997 to Jun 1997, India This project deals with Student Admission and their Registration details developed through Visual Basic 5.0 and Oracle 7.3 for SCOT COMPUTER EDUCATION. In this project maintain registers Student Details, Batch Details, Student Performance Register, Semester Details which contain information of a student at the time of enrollment for a course. When once the student joins a batch, the corresponding batch faculty maintains records pertaining to the student’s performance. Necessary Validation is taken care that a student can take more than one semester and not less than three semesters. His performance in their module tests and Student Installment fees are generated using Crystal Reports.

Current Volunteer Opportunities

Lead Senior IT Consultant Gurukul September 2016 to Current Bellevue, WA Currently Volunteering in Gurukul for a non-profit organization in the IT Committee department, helping to manage resolving tickets, migration of data, data clean and various other technologies.

• Working/ managing resolving various tickets and solve them on a periodical basis.

• Focused on automation integration monitoring and configuration management.

• Expertise in migrating the registration/student’s evaluation data successfully.

• Support and maintain existing SharePoint solutions: Gather change requests from users, requests with implement improvements, etc.

• SharePoint user administration and content management and good exposure to SharePoint development.

Educational Qualification

GNIIT in National Institute of Information Technology, Bangalore India Bachelor’s Degree in Arts, Bangalore India

• Microsoft Certified Technology Specialist (MCTS) in SQL Server 2008 Database Development.

Curriculum Vitae of Anitha PT Page 8 of 8

SQL Server 2008 Implementation and Maintenance.

• Microsoft Certified Solution Developer (MCSD)

Contact this candidate