Sr Developer/DBA

Smitarani Patro *****.********@*****.***

+91-903******* __________________________________________________________________

STATEMENT OF PURPOSE

I believe the true motivation comes from really enjoying what one is doing and being highly involved in it. I am an energetic individual seeking challenges, which provide me with enriching experiences and opportunities to grow and develop myself. My aim is to work with a company, which believes in teamwork, respects talent, rewards performance and provides scope for long-term relationship. I am sure of obtaining the same at your esteemed organization.

OBJECTIVE

To be an effective team member embracing risks and challenges with constant learning opportunities, scope of sharing knowledge thereby contributing to the growth of the organization and self.

EDUCATIONAL QUALIFICATION

MCA from Punjab Technical University.

PROFESSIONAL EXPERIENCE

---------------------------------

SQL Server DBA with over 1.9years IT experience and having knowledge about PHP.

Work Exp:

Working for Mahindra Satyam, Hyderabad from June 2010 to till date as a SQL DBA For production Support.

24/7 Activities as a Production Support DBA:

Junior SQL DBA

Tenure :( June '2010 to till now)

Core Responsibilities

1. Flatten/Rebuild SQL Servers

2. up gradation SQL servers

3. Login/Access Permissions

4. Security Updates

5. SQL Job Issues, implementing Alerts

6. Implementing Snapshot

7. Regular/Scheduled Server maintenance

8. Build Installations

9. Database Migration

10. Backups/Restores

11 .SQL/IIS Issues

12. Server Setup / Configurations / Performance Tuning

13. Database Maintenance tasks

14. Environment Refresh

15. Application Issues

16. DTS, SSIS, SSAS, Replication / Log shipping / Database Mirroring Setup and maintenance

17. Analytical Troubleshooting of environment issues

18. T-SQL

19. Implementation of SQL Logins, Roles and Authentication Modes as a part of

Security Policies for various categories of User Support.

20. Maintaining the database consistency with DBCC at regular intervals

21. Monitoring SQL server performance using profiler to find performance and dead locks.

22. Rebuilding the indexes at regular intervals for better performance

23. Designed and implemented comprehensive Backup plan and disaster recovery

strategies Implemented.

24. Monitored and modified Performance using execution plans and Index tuning.

25. Rebuilding the indexes at regular intervals for better performance

26. Involved in trouble shooting and fine-tuning of databases for its performance

and concurrency

27. Complete documentation about the database

28. Export or Import data from other data sources like flat files using Import/Export

of DTS

29. Recovering the databases from backup in disasters

30. To analyze long running slow queries and tune the same to optimize

Application and system performance.

31. To set up SQL Server configuration settings.

PROJECT EXPERIENCE

Company Mahindra Satyam

Team Size 6

Duration June ‘2010 to October '2011

Role Junior SQL DBA

Project Name OEM(Original Equipment & maintenance)

Project Details OEM Team handles 11 applications with highly critical data. Most of the applications are integrated. Hence maintaining all the applications is equally important. We maintain a QA environment (Dev + Test], which includes 340 SQL servers 2000/2005, also includes the VMS with IIS 6.0 installed. Where we have to update the databases constantly with the production equivalent data, also maintain and upgrade the IIS servers and upload the metadata to production equivalent.

All the builds and patches and hot fixes released by the Dev team are installed on the QA servers and are released for testing. Analyzing the patches for bugs and record them for game plan meets with Dev and test teams. Performance tuning, replications, restoration and backups strategies are planned on situation basis. All so we handle the server setups and configurations, installing the SQL 2000/2005, flatten/rebuild the servers. Performance tunings.

Mainly we get the application upgrades in form of patches and

Builds as per schedule. Build are schedules as per the bugs identified all throughout the quarter, which are installed later by us and release to test teams and further to UAT.

Responsibilities Flatten/Rebuild SQL Servers, Login/Access Permissions, Security Updates, SQL Job Issues, Regular/Scheduled Server maintenance, Build Installations, Handling DTS packages, Backups/Restores, SQL/IIS Issues, Server Setup/Configurations, Database Maintenance tasks, Environment Refresh, Application Issues, DTS, Replication/ Log shipping Setup and maintenance, Analytical Troubleshooting of environment issues, T-SQL

Tools SQL Profiler, Database Tuning Advisor., IIS 6.0

OS Windows 2003 servers x86/x64

TECHNICAL EXPOSURE

RDBMS : SQL 2000/2005/2008, Oracle9i

Language : T- SQL, C

Operating System: Windows 95/98/ME/XP/2000/2003/2007/Vista (32&64 bit Architecture)

PERSONAL PROFILE

Name : Smitarani Patro

D.O.B : 10.10.1985

Mailing Address : *****.********@*******.***

Permanent Address :Badagada brit colony

EB-469,Bhubaneswar

751018,Orissa

Date: Name:

Contact this candidate