Ushasri Oddiraju

Email: adknoz@r.postjobfree.com

Mobile:91-789*******

Experience Summary:

● Over 12 years of expertise as SQL DBA, Microsoft application maintenance and ITIL service management and Area of Expertise:

● SQL DBA

● Application Support

● Service Operations, Monitoring and Control

● Service Transition

Certifications:

● MCTS- SQL server 2012

● MCITP-DBA SQL Server 2005

● MCTS- SQL server 2005

● ITIL V3 Foundation

● JSE achievers award in Accenture .

Technical Expertise:

● Proficient at using SQL versions 2000 through 2017on Windows NT/2000/2003, server 2008 and 2012.

● Always-On configuration and maintenance

● SQL server upgradation and migration

● Replication setup and maintenance

● SQL Jobs Creation and maintenance

● Backup and Restore

● Setting up SQL Server Mail and alert configuration.

● Security of Databases (User permissions)

● SQL Profiler for Performance tuning

● Data Partitioning on SQL tables

● Data sync and refresh from Prod to UAT/DEV

● SSIS Package development and maintenance

● SSRS setup and maintenance

● SSAS Support

● Linked Servers setup

● Documentation on day to day incidents and solutions

● Review deployment steps and deploying Applications on the server

● Security patch up gradation and server reboots

Functional Expertise:

● Coordinate and deploy all changes into different environments

● Troubleshooting production issues and creates bugs to fix them.

● Coordinate and execute the delivery of any special environmental needs for the project builds

● SDLC and ITIL process

Employment History:JOB PROFILE:

1

Ushasri Oddiraju

Email: adknoz@r.postjobfree.com

Mobile:91-789*******

Organization: 3i-Infotech consultancy Services, India. Period : May-2016 to Till Date

Project Name:S3 Partners Data Analytics, New York. Designation:Senior Software Engineer-SQL DBA

Responsibilities:

As a SQL DBA in S3-Partners data analytic portal support team, I manage databases with 100% SLA and 99.99% availability for applications.

● SQL security and access on DB

● Always on Support and configuration

● Scheduled jobs creation and maintenance

● Performance tuning

● Backup and restore

● Database migration from 2012 to 2017

● SQL data partitioning on tables

● Index maintenance

● DR Fail-over and Fail-back of Production SQL servers

● Alert configuration and monitoring

● SSIS package development and supporting

● SSRS report configuration and supporting

Organization: Tech Mahindra Services PVT Ltd.

Period : Sept-2012 to Oct-2015

Client : Microsoft Corporation-India

Designation:Lead Associate

Responsibilities:

As a DBA I am the primary contact for two mission critical business impacting applications in Microsoft product activation Support team. I take care of all DB maintenance activities for 4.5 TB DB s in production.

● Security and access on DB

● Mirroring and Always on configuration and maintenance

● Replication setup and maintenance

● Scheduled jobs maintenance

● Performance tuning

● Backup and restore

Supported two applications technically as SME at L3 level. Maintained applications at maximum availability within agreed upon SLAs with customers.

Published KB Creation/ updating tracker report which enhanced the knowledge base repository and in turn caused shift left to L2.

Tracking Stay current reports on production server inventory and make sure all the servers are compliant to the policies.

2

Ushasri Oddiraju

Email: adknoz@r.postjobfree.com

Mobile:91-789*******

Organization: T-Systems Malaysia, SDN BHD

Period : Oct-2010 to May-2011

Project Name:Philips Global Services.

Designation:SQL DBA

Responsibilities:

● Moving all APAC Philips database servers from different country data centers to one single data center located in Singapore.

● Installing and configuring SQL server 2005/2008 in all the environments as per the requirement.

● Security administration on all the SQL servers.

● Performance tuning and disaster recovery plans implementation through log shipping and mirroring.

● Replication setup and maintenance jobs in all the environments.

● Installing security patch upgrades for production and pre-production environments. Organization: IBM Global Services.

Period : Apr-2010to Aug- 2010.

Project Name:Maxis Telecom Services

Designation:SQL DBA

Responsibilities:

● As part of Service management below were my responsibilities:

● Installing and configuring SQL server 2000/2005/2008 in all the environments as per the requirement.

● Security administration on all the SQL servers. Performance tuning and disaster recovery plans implementation through log shipping and mirroring. Replication setup and maintenance in all the environments.

Installing security patch upgrades for production and pre-production environments.

● Deploying change requests in production.

Organization: Accenture Services PVT Ltd.

Period : Dec-2005to Jun- 2009.

Project Name:Microsoft Service Transition

Designation:Software Engineer

Responsibilities:

My role involves all the below mentioned activities:

● Installing and configuring SQL servers for new applications/for advanced version of an existing application development in both production and pre-production environments.

● Creating and maintaining databases in production environment

● Taking backups and restoring databases according to the requirement

● Monitoring database jobs and alerts of all production databases.

● Configuring linked servers.

● Applying patches and security upgrades on servers.

● Deploying the bug/hot fixes into production and pre-production environments

● I have set up pre-production environments according to the project requirements and deployed all the builds into all pre-production environments including UAT.

● For all newly developed applications I have deployed the new releases into the production environment also.

● Creating logins and giving access for users and roles.

● Creating and maintaining replication and log shipping according to the requirement

● Deploying the 2 tier and 3 tier applications in production servers 3

Contact this candidate