Ushasri Oddiraju
Email: *******.*@*****.***
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: *******.*@*****.***
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: *******.*@*****.***
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