Rajendra B

Database Administrator

MS SQL Server & Oracle Server

adkk7n@r.postjobfree.com +91-807*******

Objective

As a database administrator, looking for challenging roles in DBA space to utilize my technical expertise and leadership skills in full potential.

Database Skills

Having around 8+ Years of experience as MS SQL Database Administrator and 2+ years of Oracle Database Administration, exploring new version and using current version features wherever applicable during client consultations.

MS SQL Server Skills

Experience on Installing, Configuring, Monitoring and Troubleshooting SQL Server.

Experience in Upgrading SQL Server to new versions and Applying Service Packs and Hot fixes.

Have good knowledge on Unattended and Slipstream Installations.

Management of Database Space, Growth Monitoring of Data & Transaction log files.

Resolving Database Corruptions and restoring with minimal or no data loss.

Experience on Security in Creating Logins, Users, providing permissions and fixing Orphan Users.

Having good experience in Backup and Recovery.

Setup SQL Server Alerts (Disk Space, TLog Full, Replication, Backup, CPU, Indexing Fragmentation etc.)

Good experience on SQL Server Agent Jobs.

Experience in creating and scheduling Maintenance plans.

Experience in Log shipping configuration and troubleshoot.

Having good knowledge in configuring database Mirroring and troubleshooting issues.

Experience in Configuring and Troubleshooting High Availability issues.

Involved in Database Migrations.

Experience on Create, Rebuild and Reorganize Indexes on tables to improve the performance as per development or application team request.

Experience on Always on High Availability configuration and troubleshooting issues.

Experience on configuring SQL Clustering and troubleshooting Cluster related issues.

Experience on Replication concepts i.e., Snapshot Replication and Transactional Replication.

Having experience with SQL Server Integration Services and SSIS packages.

Knowledge on Configuring SQL Server Reporting Services and creating data sources.

Have knowledge on Windows Server administration.

Experience on Windows Clustering.

Have knowledge of Active Directory concepts and worked on Active Directory.

Oracle Server Skills

Having good experience in creating databases.

Experience in administering database security.

User Account management: Creating Users, disabling users, Managing roles.

Experience in Upgrading databases from one release to another.

Database/Schema refresh using Export/Import utility.

Monitoring & Managing Table spaces and data files growth.

Deploying database objects between Development, QA and Production environments.

Experience in monitoring storage and adding datafiles to Tablespaces.

Knowledge on backup database tables with data and structures for selected schemes.

Good knowledge on creating and refreshing Materialized views.

Having experience in creating Database Links.

Scheduling automation jobs using crontab.

Creating and Rebuild Indexes on tables to improve the performance as per requirement.

Monitoring blockings and acting as per application team suggestions.

Linux Skills

Having good knowledge on Linux operating system and commands.

Experience on managing volumes and resolving space issues.

Experience in managing files and directories.

Experience on automating scripts using Crontab.

Good knowledge on managing services.

Education

B. Tech from Jawaharlal Nehru technological university, Hyderabad.

Year - 2008-2012.

Experience

Concentrix Bangalore

Currently working as Database Administrator from Dec 2015 to till date.

Unisys Hyderabad

Worked as a Software Engineer from Aug 2012 to Dec 2015.

Technical Skills

RDBMS : MS SQL Server 2016/2014/2012/2008R2/2008 and 2005.

: Oracle 11g/12c

Operating System : Windows Server 2016/2012R2/2012 2008R2/2008.

: Oracle Linux

Tools : SQL Profiler, Performance Monitor, Oracle Designer, Lab128, Opsview,

Jira, Service Now and Remedy.

Project 3

Client : KNEIP

Duration : From May-2020 to till date

Role : Database Administrator1

Roles and Responsibilities

Verifying all databases as per the checklist.

Creating Test and Development databases as per requirement.

Creating users and assign permissions based on user requirements.

Monitoring Tablespaces space of databases and adding wherever required.

Monitoring Backup logs and troubleshooting the failed backups.

Restoring backups in development servers as per dev team request.

Actively working on database migrations from Oracle 11g to 19c.

Creating Indexes as per data architect team suggestions.

Rebuild Indexes as per app team request.

Scheduling automated scripts through crontab.

Verifying space on mountpoints and clearing to resolve space issues.

Reviewing alert log and fixing issues if any.

Project 2

Client : Concentrix IS and MMS

Duration : From Dec-15 to till date

Role : Database Administrator1

Roles and Responsibilities

Involving in Installation, Configuring and Maintenance of SQL Server Instances.

Applying Service Packs and Hot fixes.

Verifying all instances are up and running as per the checklist.

Creating users and assign permissions based on user requirement.

Monitoring disk space of all the Servers and freeing up space.

Managing Backups daily and troubleshooting the failed backups.

Recovering and Restoring databases from backups in disaster situations.

Restoring backups in development servers as per dev team request.

From time to time recover the databases to a specific point of time, as per the requests.

Fixing orphaned users.

Managing the Migration of SQL Server 2005 databases to SQL Server 2012.

Creating Indexes as per Dev. /App team request.

Rebuild and Reorganize Indexes as per app team request.

Scheduling and maintaining routine SQL Agent Jobs, Alerts and Maintenance Plans.

Manually triggering SQL Agent Jobs as per development team request.

Troubleshooting various problems that arise in a day-to-day work and fix the issues.

Reviewing SQL Server and SQL Server Agent Error Logs.

Documenting major changes to the SQL Servers.

Monitoring and Troubleshooting Log Shipping Jobs.

Working on 2-node cluster and monitored through cluster administrator.

Working with Always on High Availability production cluster servers.

Creating and managing SSIS packages.

Project 1

Client : Microsoft

Duration : Aug-12 to Dec-15

Role : Software Engineer

Roles and Responsibilities

Involving in Installation, Configuring and Maintenance of SQL Server Instances.

Applying Service Packs and Hot fixes.

Verifying all instances are up and running as per the checklist.

Creating users and assign permissions based on the level of database access the user would need.

Fixing orphaned users.

Managing the Migrations of SQL Server 2005 databases to SQL Server 2012.

Monitoring disk space of all the Servers and freeing up space.

Managing Backups daily and troubleshooting the failed backups.

Recovering and Restoring databases from backups in disaster situations.

Restoring backups in development servers as per dev team request.

Manually triggering SQL Agent Jobs as per development team request.

Troubleshooting various problems that arise in a day-to-day work and fix the issues.

Reviewing SQL Server and SQL Server Agent Error Logs.

Documenting major changes to the SQL Servers.

Monitoring and Troubleshooting Log Shipping Jobs.

Contact this candidate