Kiranmai Medicherla

ad2xu6@r.postjobfree.com

Mobile: 832-***-****

SQL SERVER and Oracle DBA with over 6 years of experience and expertise providing 24/7 support for standalone and clustered environment. Managed Production databases with sizes ranging from small to large (Gigabytes to Terabytes). Performed and Implemented test plans for Disaster Recovery, resolved performance in SQL Server using inbuilt and external tools to solve problems in timely manner through tickets. Proposed and implemented backup and recovery strategies. I am proactively involved in testing and supporting continuous, next-generation database solutions in SQL server and other Server environments to improve system performance and business continuity.

Skills

• Installed and configured SQL server Instance.

• Worked extensively on Creating and configuring sql server instance and databases.

• Worked on backups, restore, and point in time recovery of databases.

• Trouble-shoot installation issues, applied service packs, and patched the environment.

• Working knowledge on creating Jobs and Maintenance plans

• Created Database users, granting and rollback of permissions and privileges

• Configured database mail to send completed and error messages.

• SQL Server Upgrade and Database Migration.

• Database Security (Creating logins, users, encryption)

• Design and implement data replication strategies

• Upgrade SQL Server databases from 2017 to SQL Server 2019.

• Configured Azure Services PaaS, IaaS and Migrated databases from on-premises to Azure cloud.

• Used Database Migration Assistant tool to migrate the large databases to PAAS server

• Configured development and test environment on Azure cloud.

• Experience in creating and monitoring SQL Server databases in Azure cloud.

• Configured and Maintained Elastic DB pools in Azure cloud.

• Experience in configuring and monitoring Geo Replication in Azure cloud.

• Configured failover groups to provide high availability for PAAS SQL Server in Azure.

• Configuring Server level and database auditing for SQL server in Azure.

• Experience in Configuring CPU, Disk, DTU usage alerts and Monitoring for Azure cloud SQL servers.

• Installed Oracle Database software using OUI

• Configured Oracle databases according to required specifications using DBCA

• Performed general Oracle Database Administration tasks

• Created users and schemas with required privileges in Oracle databases

• Managed users, roles and created specific user profiles in Oracle

• Allocated data files and managed tablespaces and Oracle database storage

• Worked on data migration and refreshes using data pump utility in Oracle

• Created and managed both public and private database links in Oracle Professional Experience

YASH technologies

Database administrator February 2012 - March 2016

• Install and configure multiple SQL Server instances.

• Document processes and procedures.

• Implement/Support Replication.

• Test and Implement High Availability solutions

• Participate in migrations and upgrade

• Advise on hardware and licensing questions.

• Ensure appropriate maintenance is in place including backups, index maintenance,

• Consistency checks and statistics.

• Worked on Performance tuning.

• Keep up to date with new releases of Microsoft SQL Server and advise on aspects that pertain to them

• Improve and maintain overall system availability for SQL Server Databases to get

• 99.95%.

• Implement HA for all business-critical databases.

• Achieve maximum performance gain for overall database performance.

• Upgrade all SQL Server databases to SQL Server 2008 or 2012/2014.

• Perform health checks and monitor database server performance.

• Proactively monitor and tune slow running queries.

• Administer database security.

• Implement database maintenance plans.

• Administer database backups

• Configured and administered Oracle Database 10g and 11g

• Installing, patching, maintaining and upgrading all Oracle software (10g to 11g) using DBCA

• Gathering and analyzing AWR report for troubleshooting purposes

• Using RMAN to create and configure a Recovery Catalog

• Using RMAN to backup the recovery catalog

• Performing constant and occasional database backup and recovery using RMAN, Data pump, Import and Export utility, clone database etc.

• Developing SQL scripts to carry out routine checks on databases. This includes checking if the Listener is running, optimal running of all databases, UNIX error messages, disk space availability etc.

SVITS Collage January 2010 – February 2012

Computer Science Lab assistant

• Installed and configured the Windows operating system on machines and worked on versions XP, Vista, etc.

• Worked on creating storage partitions and allocating disk space as per requirements.

• Worked on creating firewall rules and installing antivirus software as per requirements.

• worked on defragmenting Windows drives for optimal performance as needed.

• Installed and configured the Linux Operating system on machines and worked on RHEL5.

• Windows OS and MS-Office skills including strong desktop support & troubleshooting

• Incident management through procedures and troubleshooting techniques Education

Bachelor of Technology (4 Year course) in E&C Engineering June 2005 - June 2009 Sree Visvesvaraya Institute of Technology and Science at Mahabubnagar, India. Certifications

Certified as Redhat Certified Engineer RHCE ID – 805************

Contact this candidate