Life Insurance Sql

RajaMohana Reddy M

SQL DBA Administrator

Proffesional summary

Having around 4.6 years of experience as a SQL Database Administration.

Experience in Installing, Configuring and Administering SQL server 2008, 2008R2, 2012 and 2014.

Managing Database security by creating users, logins and assigning Roles and Permissions.

Working experience in Database Backups, Restores and point-in-time recovery.

Daily activities include monitoring Database, checking error logs, checking the log file size, and free space in the data drives, connectivity of the databases.

Configuring, Scheduling and administering routine Jobs, Tasks, Alerts and Maintenance Plans.

Experience in Upgrading and Migrating databases from SQL Server 2008, 2008 R2, 2012 and 2014.

Configured and maintained replication, log shipping and mirroring for high availbility

Experience in Disaster Recovery and security Management Operations.

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

Experience in implementing different types of replication models like snapshot and transactionl on basis of business specification.

Monitoring the transactional replication on daily basis with replication monitor and troubleshoot the replication errors and replication jobs.

Experience in alwayson environment.

Experience in setting up high availability environments like active-active and active-passive clustering.

Configuring SQL Server cluster in Nodes.

Configured and maintained SQL Server 2008R2, 2012 fail over clusters.

Administrating SQL Server High avilability and Disaster Recovery strategies.

Performance and tuning, Query optimization using SQL profile, DTA, perform, DMVs, DBCC and SSMS.

Ability to handle multiple projects with a good grasping knowledge in understanding the business.

Capable and experienced working independently as well as in a team environment.

Worked on 24X7 supports on shift basis.

Career graph

Working as SQL Database Administrator with HCL Technologies LTD, Bangalore from June 2020 to till now.

Worked as SQL Database Administrator with Zensor Technologies Hyderabad from June 2016 to JAN 2020.

Academic details

Bachelor of Technology (Information Technology) from JNTU, Hyderabad.

Skill Set

Database : Sql server 2008 & 2008R2, Sql server 2012, 2014 and 2016.

Operating system : Windows server 2008 and 2008R2, Windows server 2012 and 2012R2.

Tools : Sql query editor, Configuration manager, Sql profiler, Perfmon.

High Availability : Logshipping, Replication, Performance Tuning, Always on, Mirroring

project #2

Client : ERIE USA

Duration : August 2018 to January 2020

Designation : Database Administrator

DBMS : Sql server 2008, Sql server 2012/R2, 2014

Operasting System : Windows Server 2008/R2/2012

Description: Erie Insurance Group is a multi-line insurance company, offering auto, home, commercial and life insurance through a network of independent insurance agents. Erie Insurance Group's geographic presence extends to 11 states and the District of Columbia, including Illinois, Indiana, Maryland, New York, North Carolina, Ohio, Pennsylvania, Tennessee, Virginia, West Virginiaand Wisconsin.

Responsibilities:

Involved in SQL Server Installation and applying service packs for servers as released requested.

Demonstrable experience of Installation, migration, upgrade and maintenance of multiple SQL Server Databases.

Demonstrable experience with backups, recovery and optimization.

Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks, blockings, deadlocks and long transactions).

Experience in configuring and maintaining data mirroring in SQL Server 2005.

Effective Disaster Recovery planning and strategy implementation by minimizing the data loss.

Creating logins, roles and granting rights assigning permissions and mappings user data base on the abstract solutions.

Assigning appropriate permissions to the users as required following the principle of least privilege.

Creating and Monitoring SQL Server agent jobs and troubleshooting as required.

Building disaster recovery systems by mirroring.

Migrating databases from one server to another server and fixing the orphaned users.

Rebuilding the indexes at regular intervals for better performance.

Monitor SQL Server services status, Jobs, SQL Server Logs, Dead locks/Blocking.

project #1

Client : OPower, USA

Duration : June 2016 TO Aug 2018

Designation : Database Administrator.

DBMS : Sql server 2005, Sql server 2008

Operating System : windows server 2008/R2

Description: Opower is a privately held Software-as-a-Service company that partners with utility providers around the world to promote energy efficiency. Through contracts with more than 90 utility companies in 35 U.S. states and 8 countries, Opower's software provides customers with better information about their energy consumption, along with personalized ways to save energy and money. Utilities use the Opower software platform to deliver key customer-facing applications that reduce energy demand and improve customer perception of the utility.

Responsibilities:

Checking daily backups full, differential and T-Log within the first few hours of failure.

Installation & Configuration of SQL Server 2008,2008R2,2012/R2 and 2014.

Administering the SQL Server by Creating User Logins with appropriate roles, creation of groups, granting the privileges to groups and creating users and assigning roles for data access.

Automating and monitoring database maintenance plans.

Creating and scheduling Full and Differential backup Jobs.

Creating and scheduling Transaction log backup Jobs.

Back up master & system databases and restoring them when necessary.

Creating and scheduling Maintenance related jobs to automate tasks such as fragmenting Indexes (Reorganizing Indexes), Rebuilding Indexes.

Monitoring Database performance and optimize performance.

Configuring and Implementing Log Shipping in Test Database Server environments.

Monitoring Logshipping related jobs such as Backup, Copy, and Restore Jobs.

Certification:-

Certified in Administering Microsoft SQL server 2012 Database (70-462)

Contact this candidate