| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Kotaiah Pentela Mobile: PHONE NUMBER AVAILABLE
Email: EMAIL AVAILABLE https://LINKEDIN LINK AVAILABLEProfile OverviewSeeking for a challenging SQL Server Database Administration position that will provide me an opportunity to utilize my skills in the growth and development of the organization and be able to effectively implement good database solutions to achieve our mutual goals.Professional Summary Over 10 Years of Experience in Microsoft SQL Server Database Administration on 2008/2008R2/2012/2014/2016/2017 versions and over 2 Years of experience as Teradata Administrator. Expertise in Database Administration on Production Servers with Server Installation, Configuration, Monitoring and Maintenance with troubleshooting capabilities. Expertise in Backup and Recovery strategies by using Rubric and SQL native tools. Strong knowledge and experience in implementing Transparent Data Encryption (TDE) for enhanced data security. Expertise in Databases creation and maintenance. Good knowledge and experience in WSFC configuration on maintenance. Expertise in Troubleshooting performance issues. Experienced in Performance tuning activities, including identifying slow running queries, missing indexes, and usage of statistics for optimization. Expertise in Database Upgradation, Migration, Security patches and SP upgrades. Fixing connectivity issues at server and database level. Maintained 1000+ databases with Max size of 20 TB. Administering SQL Server High Availability and Disaster Recovery strategies. Experience in Import, Export, Backup and Database Monitoring tools. Experience in Creating Jobs and Sending Alerts using DB Mail. Experience in the provision and managing Cloud-based SQL server instance which is in Virtual Machine Experience in the provisioning and managing Azure SQL Database and Azure SQL Managed Instances. Deploy and manage Azure compute resources. Monitor and maintain Azure Workspaces, VM s and Azure resources. Setting up auditing and threat detection on Azure SQL databases to monitor for potential vulnerabilities or suspicious activities Continuously improve quality parameters to reduce incidents and document known errors or work arounds in the shared Knowledge Base. Handled Major incident calls, raised PSS cases for critical issues. Dedicated to providing 24x7 production support, ensuring seamless operation and minimal downtime for critical systems. Strong understanding of SQL certifications and MCSE certifications, with a commitment to continuous learning and professional development.Technical Skills
Databases: Microsoft SQL Server 2008-2022SQL Server Components: SSMS, SSIS, SSRS, SQL ProfilerSAS Tools: SAS 9.1.3/9.2, SAS EG, SAS Management Console, SAS WRSOperating Systems: Windows 2008/2012/2016/2022, LinuxOther Tools: Shell script, PowerShell, ServiceNOW, JIRA, Hummingbird Exceed, WinSCP, Rubrik, Solar windsCloud Technologies: AZURE SQL, DataLake, Data FactoryProject Experience:Client: Metropolitan Utilities District - Omaha, NE, USA May 2024 - PresentRole: ASQL Platform DBAEnvironment: MS SQL Server 2014/2016/2017/2019, AZURE SQL, SNOWFLAKE, JIRA, SSIS, DB2 Migrations, SSAS, SSRS, PowerShellRoles and Responsibilities: Work proactively on avoiding potential issues and improve on the health monitoring of the servers.
Provisioning and configuring Azure SQL databases, including setting up security, backups, and high availability options like failover groups Configuring, Monitoring and Troubleshooting Always ON SQL servers. Monitoring the jobs and handling the performance issues of the AX related user and batch jobs. Work on Planning and implementing Disk expansion, SKU Upgrade and SQL patching activities. Prepare and implement the SQL custom indexes during deployment activities. Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers. Worked on the Disaster Recovery setup of On-Premises Always ON SQL environment with an Azure environment. Ensuring high availability and disaster recovery by configuring geo-replication, failover groups, and long-term backup retention policies. Monitoring database performance, query execution, and resource utilization using tools like Azure SQL Analytics Performing regular Data refresh activities from Production to the development and test environments Managing database users, roles and permissions along with implementation and maintaining database security measures. Work on the PWC and EY data tool extractions for the purpose of auditing. Work on automation of SQL health check reports and extracting Audit reports. Handling of critical P1 and P2 issues and preparing of RCA document for Post mortem analysis of the issues. Work on regular monthly patching activities along with planning of SQL activities. Documenting Knowledge base articles for maintenance.Client: Acushnet Golf, Chennai, India Jan 2023 - Jan 2024Implementation partner: Atlas Systems
Role: SQL Platform DBAEnvironment: MS SQL Server 2008/2008R2/2012/2014/2016/2017, DB2, AZURE SQL, SCSM, Service NOW, SSIS, Solar windRoles and Responsibilities: Management of SQL Servers, databases, storage management for database sizing 6TB. Installation and configuration of MS SQL Server 2017, 2016, 2014, 2012, 2008R2 / 2008 and applying the latest service packs & hot fixes. Upgrading/Migrating the SQL Servers Instances/Databases. Implementation of High Availability Always ON Production Servers. Having knowledge on Fail over SQL 2012/2014/2016 Cluster. Creating the Linked Servers, Endpoints, Operators & Database Email. Scripting out all the SQL Stuff before migrating the SQL Instances.
Monitoring & troubleshooting the Always ON & Replication Issues. Monitoring & troubleshooting the Maintenance Plan & SQL Job Failures. Implementations of SQL logins, roles, and authentication modes as part of security policies for various categories of users. Troubleshooting the Fragmentation of Indexes, databases & Disk Space Issues of database servers. Designing the Maintenance plans and implementing the comprehensive Backup strategies for Disaster Recovery. Implemented Post Installations recommendations and Configurations Like (Temp DB files configurations, SQL Memory, Lock pages in memory and Configuring the Maintenance jobs etc.) Checking the performance using the DMV s and Database Consistency by Using DBCC commands. Worked on creating azure backups and removing local backups. Expertise in Migrating OnPrem SQL VMs to Azure IAAS VMs. Worked on database index maintenances of SQL Azure PaaS servers.Client: Himalaya, Chennai, India Aug 2018 Dec 2023Implementation partner: Atlas Systems
Role: SQL DB AdministratorEnvironment: SQL Server 2008R2/2012/2014/2016/2019/2022, SSIS,SAP, SAP HANARoles and Responsibilities: Responsible for troubleshooting issues related to non-production servers like job failures, package execution failures, server performance etc. Responsible for checking the health of the Database, Recovering from consistency errors in the Database. Applied Security Patches and Service Packs on 2008 versions on Standalone servers. Handling SQL Server installation, configuration, maintenance, and connectivity issues. Experience in Configuring users, Controlling, and monitoring user access to the database, and maintaining system security. Setup and Administration of Database Mirroring and performing the Failovers from Principle to Mirror and vice versa. Recovery of the database during crash or data Loss. Fixed connectivity issues of the users to SQL instances remotely and locally. Creation of Logins, Roles and granting rights, assigning permissions and mapping user databases. Troubleshoot the SQL SERVER Performance using SQL profiler, extended events, and dead locks issues. Maintaining the Database Consistency with DBCC commands (CHECKDB) at regular intervals Checking the status of Backup troubleshooting the failed backups and Restoration of databases and Scheduling jobs in SQL Server. Troubleshoot Performance related issues with respect to the server performance. Contributing to Knowledge Management content creation and maintenance.Client : Qlikview, Charlotte, India Jun 2017 - July 2018Implementation partner: Atlas Systems
Role: SQL DB AdministratorEnvironment: SQL Server 2012, SQL Server 2014, AWSRoles and Responsibilities:
Implemented EULA security project from scratch to end using SQL server 2014 and SSRS. Installing, configuring, managing, monitoring and troubleshooting SQL Server.
Configured Mirroring high availability.
Troubleshooting performance issues and tuning the database for better performance. Running SQL Server profiler to troubleshoot the data issues reported by users.
Monitoring issues related to database locks/blockings/deadlocks.
Configuring SQL Server Reporting Server, Database Mails to send notification for alerts.
Daily checking the issues like backup failures, failed logins and resolve the issues.
Monitored Hot Fix releases, patches and evaluated their importance and installed them. Responsible for all the End-User community (400 + users) on daily basis to serve their day to day functional needs on Qlikview client.
Responsible for End-User s data storage and conduct forecast on capacity planning and update to Business Managers on Quarterly basis.
Other SAS Administration Tasks: SAS Desktop Software Packaging Initiated Enterprise wide SAS 9.1.3/9.2 Desktop software packaging for SAS ECO basic, SAS/ STAT+, SAS EG, SAS Enterprise Miner client, and SAS Text Miner Client. This was initiated to use single set of SAS Software packages for 1800 + SAS users across the enterprise instead of separate packages for every department that use SAS.
Client : SRS Health, Chennai, India May 2016 - May 2017Implementation partner: Atlas Systems
Role: SQL DB AdministratorEnvironment: SQL server 2008 R2, SQL server 2012, performance monitorRoles and Responsibilities:
Support to application upgrades and SQL server installations. Troubleshooting performance issues and tuning the database for better performance. Running SQL Server profiler to troubleshoot the data issues reported by users.
Monitoring issues related to database locks/blockings/deadlocks.
Configuring SQL Server Reporting Server, Database Mails to send notification for alerts.
Client : United Health Group, Hyderabad, India Mar 2014 - Apr 2016Implementation partner: ITC infotechRole: SQL AdministratorEnvironment: SQL Server, Teradata, Service now, Oracle, Teradata DWHRoles and Responsibilities:
Monitor daily jobs and fixes job failures. Loading data from OLTP to Teradata DWH environment. Used Fastload and multi-load data to load from dev to QA and Prod. Installing, configuring, managing, monitoring and troubleshooting SQL Server.
Applying SQL Standards on all SQL servers according to the prescribed standards.
Able to perform the Failover and Failback activities in Cluster environment.
Daily checking and resolving the tickets depends on the priority levels.
Education: MCA from ACHARYA NAGARJUNA UNIVERSITY (ANU), 2009, Andhra PradeshCertification: (Microsoft Certification ID: 989920617) AZ 900 Microsoft Azure Fundamentals
AZ 104 Microsoft Azure Administrator DP 300 Administering Microsoft Azure SQL Solutions |
