Experience Summary
1. Having 2 Years 10 Months of IT Experience as an Assistant Software Engineer in AP Online Ltd, as SQL DBA.
2. Experience of managing multiple MS SQL 2008, 2008 R2 & 2012 RDBMS on large systems.
3. Proficient in providing high availability service like mirroring, replication and log shipping.
4. Extensive knowledge in Stored Procedures, Views, Triggers, Cursors, Functions, Indexes.
5. Good knowledge in understanding execution plans, Query optimization/tuning, system management views and DBCC commands.
6. Exceptionally well organized, quick learner and willing to work hard to achieve employer objectives.
7. Worked extensively in SQL Development and SQL DBA activities.
8. Provided break through solutions, and actively involved in team discussions during critical decision making situations.
9. Strong self-sufficiency and initiative working on Database projects.
Qualifications
• M Tech in Information Security (2012) in SRM University with 66%.
• B Tech in Information Technology (2010) in TKRCET affiliated to JNTUH with 64%.
• Intermediate in M.P.C (2006) in Sri Chaitanya Jr College with 73%.
Technical Knowledge
Operating Systems : Familiar with Windows Family.
Framework : .Net Framework 2.0/3.5
Languages : HTML and T-SQL.
RDBMS : SQL Server 2008 R2/2012.
BI : SSIS, SSRS.
Work Experience
1. Working as Assistant Software Engineer in AP Online Ltd (A Joint venture between Govt. of A.P, T.S and TATA Consultancy Services)
Since June-2013 to Feb-2016.
Project: #1 April-2015 to Feb-2016
Project Title : NTR Bharosa Pensions
Team Size : 28
Client : Government of Andhra Pradesh.
Environment : .NET 4.0 (ASP. NET, C#.NET), WINDOWS(C#.NET)
Database : Sql Server 2008 R2/2012.
Role : Sql Server DBA.
Project Description: The Government of Andhra Pradesh is committed to secure dignified life to all the poor and vulnerable, particularly the old and infirm and to support their minimum needs to bring happiness in their lives. In pursuit of this overarching goal, in spite of the challenging financial conditions, orders were issued vide G.O. Ms. No. 113, enhancing the NTR Bharosa Pension for Old Age, Widow, Weavers, Toddy Tappers and AIDS patients and the People With Disabilities.
Contribution:
1. As an effective team member guiding the team in technical aspects as Administration and developments are key activities.
2. Data Base Designing & modeling, maintaining database integrity, tuning and optimizing SQL Queries.
3. Written Stored Procedures, Views, Triggers, Cursors, Functions and Indexes.
4. Analyzing and Understanding Query Execution Plans and SQL Locking and Blocking.
5. Setup and Configuration of High availability concepts like Replication. Mirroring and log shipping.
6. Performed daily, weekly, and monthly data maintenance tasks.
7. Planned, implemented all types of Backups (Full, Differential, Transactional) and Restore Operations.
8. Up gradation and Migration of SQL Server databases.
9. DATA BASE monitoring (Space management, CPU and Memory utilization, Data base designing SQL jobs monitoring, managing TEMPDB, INDEXES, checking performance counters ).
Project: #2 Nov-2014 to Mar-2015
Project Title : AP CRDA (Amaravati Pensions)
Team Size : 13
Client : Government of Andhra Pradesh.
Environment : .NET 4.0 (ASP. NET, C#.NET), WINDOWS(C#.NET)
Database : Sql Server 2008 R2/2012.
Role : Sql Server DBA.
Project Description: The Government of Andhra Pradesh has enacted Andhra Pradesh Capital Region Development Authority Act. No. 11 of 2014, for the declaration of the New Capital Area for the State of the Andhra Pradesh and establishment of the Andhra Pradesh Capital Region Development Authority for the purpose of Planning, Co-ordination, Execution, Supervision, Financing, Funding and for Promoting and Securing the Planned Development of the Capital Region and Capital City Area for the State.
Contribution:
1. As an effective team member guiding the team in technical aspects and Administration, developments are key activities.
2. Data Base Designing, Writing Stored procedures, functions, tuning, optimizing SQL Queries, backups and restore operations.
3. Analyzing and Understanding Query Execution Plans and SQL Locking and Blocking.
4. Actively participated in migrating servers from one server to other servers.
5. DATA BASE monitoring (Space management, CPU and Memory utilization, Data base designing SQL jobs monitoring, managing TEMPDB, INDEXES, checking performance counters).
Project: #3 June-2013 to Oct-2014
Project Title : WDP (WAGE DISBURSEMENT PORTAL)
Team Size : 42
Client : DOP (DEPARTMENT OF POST OFFICE)
Environment : .NET 3.5 (ASP. NET, C#.NET), WINDOWS(C#.NET)
Database : Sql Server 2008.
Role : Sql Server DBA.
Project Description: Central Government brought an act National Rural Employment Guarantee Act (NREGA), to provide employment for wage seekers, and pensions for pensioners through Aadhaar or Local Bio metric authentication. This project is to enroll wage seekers or pensioners from districts allotted to DOP, paying wages and pensions to wage seekers and pensioners respectively, providing account numbers and Pass books.
Contribution:
1. Created and managed database objects that include Tables, Views, Stored Procedures, Cursors and Triggers to implement Business Logic.
2. Experience on writing Joins, Sub-Queries and Indexes.
3. Created numerous ordinary to complex queries involving multi-table joins, Union, correlated sub-queries, CTE’s and views for diverse business requirements.
4. Planned, implemented all types of Backups (Full, Differential, Transactional) and Restore Operations.
5. Worked as a part of team and provided support whenever required.
6. Interacted with clients for collecting business requirements and resolved various technical issues.
