Home

tharak - sql dba

[email protected]

Location: Lufkin, Texas, USA

Relocation: yes

Visa: H1B

Professional Summary: Having 9+ years of SQL Server experience in MS SQL Server (2005, 2008, 2008R2, 2012 and 2014) on Windows (2003, 2008, and 2012) environment. Experience in upgrading MS SQL Server 2005/2008/2008R2 to MS SQL Server 2012,2014/2016/2017/2019. Migrated on premise SQL servers to Google Cloud SQL or MySQL instances and to IAAS instances in GCP, Azure Managed and IAAS instances. Experience using Azure DMA and DMS to migrate on premises databases to Cloud. Excellent working knowledge of various new features of SQL server Experience in creating Tables, Views, cursors, stored procedures, functions, and database triggers. Experience in SQL server 2008/2008R2/2012/2014/2016 clustering, Active-Active and Active-passive. Experience in SQL Server 2008/2008R2/2012 Replication and mirroring. Experience in SQL Database/Server/Instance/Cluster upgrade and migration. Experience in applying SQL server patches, hot fixes, cumulative updates, and service packs in clustered and non-clustered environments. Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges Implemented Side by Side Migration of old versions of MS SQL SERVER to 2008/2012/2014/2016/2017/2019 versions. Experience in providing 24x7 Production support. Experience developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS), developing reporting solutions using SQL Reporting Services (SSRS). Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (Bulk Insert, BCP, DTS and SSIS). Extensively used performance monitor/SQL profiler to solve dead locks/long running queries. Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages based on Business or application needs. Implemented Backup and Restore in SQL Server using Native SQL Backups and using Third party tools like VERITAS NetBackup and RClone utility for Cloud instances. Hands on experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000 DTS/SSIS, Reporting & Analysis Services. Experience in migration of Data in Excel, Flat file, and Teradata to and from MS SQL Server by using SQL Server SSIS Hands on experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques, T-SQL (DDL and DML) Coding and installing, upgrading, configuring and implementation of MS SQL Server 2008/2012/2014/2016/2017/2019 in Windows Environment. Very good in implementing security, configuring subscriptions for SSRS reports. Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS Experience in using Performance Monitor/Profiler to monitor and solve performance issues like long running queries. Used Native Tools, Query Analyzer, Execution Plan, Live Query Statistics, Query Store, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, Resource Monitor and Activity Monitor for monitoring, tuning, and troubleshooting purpose. Experience in handling locking, blocking and deadlock situations causing performance issues. Experience in implementing and configuring databases on Cloud Platforms such as Azure and GCP. Experience setting up Azure Data Lakes and Data factories for the ETL Development team Hands on experience in migrating the on prem databases into Cloud SQL in GCP using different no downtime Migration tools. Experience in implementing database consistency checks using DBCC Utilities. Having nice experience of monitoring client servers using IDERA. Connecting remote SQL Servers as Linked Servers and AdHoc SQL Functions like Open rosets. Advanced understanding of SQL Server Disaster Recovery (DR) requirements, capacity planning, MS SQL Clustering, Performance tuning and maintenance plan set up. Hands on experience with Database Engine Tuning Advisor, creating and rebuilding Clustered and Non- Clustered Indexes. Implemented STRIIM tool to migrate databases from on prem to different Cloud databases with very minimal or no downtime. Experience in maintenance of Database authentication modes, creation of users, configuring permissions and assigning roles to users. Implemented different Indexing and other maintenance strategies using Ola HallenGren scripts. Experience in Code Optimization and improving efficiency in databases including indexing, Recompiling Stored Procedure, user defined functions and performing other maintenance tasks. Hands on experience in migrating SQL databases to Snowflake. Hands on experience on Google Cloud Core Infra, Cloud SQL DB setup and migrations and MySQL servers in cloud. Proven knowledge on working with creating VMs or EC2 instances in GCP/Azure/AWS, version controlling using GIT, GitHub, installing build tools such as Maven, Gradle and containerizing Docker environments. Good team player, optimistic, strong interpersonal and communication skills. Technical Skills: RDBMS SQL Server 2000-2019, Cloud SQL, Cloud MySQL, Business Intelligence Tools SSIS, SSRS, SSAS Monitoring Tools Native SQL Monitor, SQL Idera Development Tools Visual Studio Data Migration Tools MSDTS, BCP, Import and Export Wizard, Flat File or Import and Export Wizard, and SSIS Packages, STRIIM, MigVisor. Languages SQL, T-SQL, Shell Backup Tools Veritas Net Backup DevOps, SVC Tools Jenkins, GitHub, Maven Operating System Windows, Linux and VMware Cloud Technologies Azure, AWS and GCP Professional Certification : Azure foundation certification AZ-900 Professional Summary: Client: Bell Soft LLC, Houston , Tx Oct 2022 Till Date Role: Sr. SQL Server Cloud Database Administrator Responsibilities: Installing, migration and up gradation SQL server 2012,2014,2016 and applying the service packs. Creating Databases as per requirement of Application Team Requirement. Keeping Track of major changes on the SQL Servers. Deployed database change scripts provided by third party vendors and development teams. Troubleshooting issues like Locking, Blocking and Deadlock. Testing DR sites of the production databases using HA technique. Managing SQL Server security like Login level, user level and object level. Implemented routine database maintenance activities, scheduled job for these activities. . Solving the requests raised by user support. Installing the SQL server 2005/2008/2008 R2/2012 and applying the service packs. Performing backups of client databases by setting up backup schedules at regular intervals also restoring databases. Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding the index Installing, migration and up gradation SQL server 2012,2014,2016 and applying the service packs. Creating Databases as per requirement of Application Team Requirement. Keeping Track of major changes on the SQL Servers. Deployed database change scripts provided by third party vendors and development teams. Troubleshooting issues like Locking, Blocking and Deadlock. Testing DR sites of the production databases using HA technique. Managing SQL Server security like Login level, user level and object level. Implemented routine database maintenance activities, scheduled job for these activities. Solving the requests raised by user support. Installing the SQL server 2005/2008/2008 R2/2012 and applying the service packs. Performing backups of client databases by setting up backup schedules at regular intervals also restoring databases. Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding the index Client: Honda North America, India Oct 2020 Sep 2022 Role: Cloud Database Administrator Roles and Responsibilities: Installation, Configurations and Administration of MS SQL Server 2019/2017/2016/2014/2012/2008/2005 in Production, Test and Development Environments. Implemented the best practices such as memory, MaxDOP and many other settings while installing and migrating SQL Servers. Upgraded old versions of MS SQL Server 2005/2008/2008R2 to MS SQL Server 2012,2014/2016/2017/2019. Architected the Migration of different data center consolidations. Migrated on prem SQL servers to GCP Cloud SQL or MySQL instances and to IAAS instances in GCP, Azure using standard migration strategies and different tools such as Azure DMS, DMA and STRIIM. Migrated Oracle and MySQL databases using different tools such as SSMA, EverSQL and STRIIM. Hands on using the migration solution MigVisor by EPAM solutions. Experience in migrating the data between servers using Import and Export Wizard, BCP, Bulk Insert and SSIS packages. Worked on daily activities such as SQL server Health Checks, tickets, and backup failures as per SLA. Experienced in performance tuning in resolving application slowness, long running query, resource issues using different DMV's, other resource governor, lock page settings. Created and managed SQL Virtual Machines (IaaS) in GCP, Azure & multiple SQL Cloud Instances (PaaS). Experience in creating the database maintenance tasks using Azure Automation. Experienced in creating and administration on multi node High Availability SQL clusters including AlwaysON. Implemented High Availability Disaster Recover solutions like Clustering, Database Mirroring, Log Shipping in SQL Server 2017/2016/2014/2012/2008 R2, 2008, 2005 and AlwaysON High Availability Groups with SQL Server 2012/2014/2016/2019. Specified users and user access levels for each segment of database. Implemented strict policies and access control rules on the SQL server security by effectively implementing different innovative AD Groups. Planned and installed upgrades of database management system software to enhance database performance by applying CU, patches, and security updates. Performed routine and scheduled maintenance services. Developed ETL and DTS packages using SSIS and reports using SSRS. Monitored SQL servers using Perfmon, SQL Profiler, Query Analyzer, Execution Plan, Database Tuning Advisor, and 3rd party tools such as SQL Idera to solve performance, blocking, deadlock, resources and long running queries issues. Identified deadlock, blocking scenarios and Perform Re indexing and Index defrag operations for the maintenance of large tables to resolve performance issues. Proactively monitored and resolved SQL Server events like service down, agent down, backup failures, job failures, SSIS package failures, distributed query failures using linked servers, unplanned cluster failovers, replication failures, mirroring failures, log shipping job failures etc. insufficient disk space for database or log to grow, database or log full errors, tempdb errors etc., Implemented strict policies and access control on the SQL server security by effectively implementing different innovative AD Groups. Created SQL DBMail alerts for various requirements such as job failures, disk space alerts and long running SQL Jobs. Implemented Resource Governor Pools to reduce the blocking process. Developed TSQL code such as store procedures, indexes, triggers etc. Written TSQL code for various data load, transformation and extraction procedures. Responsible for creating Monitors and Rules in SCOM based on the monitoring requirements Tuned different scripts written in TSQL for efficient application and database performance. Configured Active Geo Replication, Failover Groups using GCP and Azure portal. Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal. Implemented various backup and restore solutions for SQL servers by using Veritas NetBackup, RClone, S3 bucket and Azure Storage Containers and scripts such as Ola HallenGren Backup maintenance solution. Implemented Transparent Data Encryption on PCI databases as per business requirements. Developed PowerShell scripts for automating different SQL maintenance activities and handling large database backups to the data domain using NetBackup. Implemented different Indexing and other maintenance strategies using Ola HallenGren scripts. Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges. Developed procedures for purging/archiving the obsolete data after certain retention period. Participated in multiple POC activities on using different migration tools such as HevoData and other monitor tools such as SolarWinds, DataDog, DynaTrace. Hands on experience on network protocols, firewall rules, Cloud Storage, stack driver monitoring and AWS RDS service. Administered Tableau, Talend, Investran, and Integrity and took the role of deployment admin. Managed offshore team members and assigned them the requests by users. Client: AETNA/ STRATEGIC OPERATIONS, Bangalore, India May 2018 Aug 2020 Role: SQL SERVER Database Administrator Responsibilities: Installing the SQL server 2000/2005/2008/2008 R2 and applying the service packs. Creating Databases as per requirement of Application Team Documenting major changes to the SQL Servers. Deployed database change scripts provided by third party vendors Troubleshooting issues like Locking, Blocking and Deadlock. Testing DR sites of the production databases using HA technique. Managing SQL Server security like Login level, user level and object level. Implemented routine database maintenance activities, scheduled job for these activities. . Solving the requests raised by user support. Installing the SQL server 2005/2008/2008 R2/2012 and applying the service packs. Performing backups of client databases by setting up backup schedules at regular intervals also restoring databases. Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding the index Installation, configuration and maintenance of the MS SQL Server 2008. Performance and tuning of SQL servers and application issues related to migration. Testing of applications for performance, data integrity and validation issues. Performed the database clean-up tasks. Development of system maintenance tasks such as Database Backup & Recovery, Database Mirroring and Replication and apply in Dev and Testing Environment. Took care of day-to-day IT operations in conjunction with IT team. Assign permission to user(s), roles), and object. Administrate security for server logins (Windows & SQL Accounts). Scripting the database consistency checks (DBCC), scheduling the scripts to run daily and weekly basis. Conducted performance monitoring and tuning using SQL Profiler and windows performance monitor. Performed installation, administration, configuration and development upgrades from 2005 to 2008. Implemented Log Shipping, Mirroring with SQL Server 2005 successfully. Supported Development Team in deploying and testing the application, which uses SQL Server backend. Implemented transactional replication between Primary Server and Read Only servers. Daily monitoring of the database performance and network issues. Client: Aegis, Bangalore, India Oct 2017 May 2018 Role: SQL DBA Admin Responsibilities: Installation, configuration and maintenance of MS SQL Server 2005, 2008, 2012, 2014. Configured SQL Server 2005 using Surface Area Configuration tool Taking backups regularly through jobs. Configuring Log Shipping, Maintain and troubleshoot Log shipping issues Responsible for database backups and restoration Database Maintenance activities like Index Defrag Created the Database and tables using design document specifications. Updated scripts for client to each Version Release. Performing the database up gradations from lower version to higher versions and database refreshes form production to development. Troubleshooting failed backup jobs. Verify the appropriate sql services are running. Check for adequate disk space for growing database files and log files. Check SQL Server jobs (look for failures). Check the SQL Server logs for errors and Windows NT Event Viewer errors. Client: Optus or SingTel, India july 2014 Sep 2017 Role: Software Engineer Responsibilities: Creating Databases as per requirement of Application Team. Managing SQL Server security like Login level, user level and object level. Monitoring the Server for High Availability of the Servers. Installing the SQL server 2000/2005/2008/2008 R2 and applying the service packs. Performing backups of client databases by setting up backup schedules at regular intervals also restoring databases. Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding the index. Daily monitoring of the database performance and network issues. Assign permission to user(s), roles), and object. Administrate security for server logins (Windows & SQL Accounts). Academic Details: Engineering (B.E) graduate in Computer Science, from JNTU Ananthapur University, India, May 2014. Keywords: business intelligence sthree database active directory information technology microsoft Arizona Texas