Sql Server database administrator

SRIDHAR BABU TELLA

Email: *************@*****.*** Mobile: (904)- 250 9961

Experience:

12+ years expertise as Senior DBA in Microsoft SQL Server 2012/2008 R2/2005/2000 7.0 management and Performance tuning, High Availability, System analysis, Design, deployment,24/7 Customer support, Consultation to new customers in terms of sizing, capacity planning for their new applications, and experience on development. Over 7+ years in Project lead experience in development, maintenance and delivering of more than 30 major premier Government Customers and different departments within the government sector.

Major Strengths:

Provided strategic direction for the database team size of 32 and functioned as the technical/project leader on projects.

Technical Architecture review of new and existing customer database work requests and what is technically possible in any given scenario.

Managed and administered 350+ databases in 40 instances. Initiated a project to consolidate servers and to remove old/unused databases. Reduced the number of databases to fewer than 182 on 34 instances, Could handled 3 million transactions per day without any performance issues.

Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager).

Created SQL Jobs as per the business logic and automated which resulted to cut the high management cost and increased productivity.

Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.

Get developed a tool for monitoring of SQL jobs /DB Activities by support team which was more helpful in terms of monitoring Jobs without login into SQL server.

Installed and configured a SQL 2008 clustered test environment.

Configured and supported replication and log shipping in both SQL 2005 and 2008.

Supervised code review of scripts with developers. Advised developers in code optimization.

Implemented SQL Server based solution to consolidate dozens of scientific data collection and reporting applications.

Safeguarding data by instilling backup, managing user access and securing databases.

Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.

Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.

Experience with Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment.

Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery.

Developed load procedures using SQL and other procedures to keep the Database current. Presented to management on a weekly basis the progress and issues regarding their data.

Participated and was a key contributor to the GUI development as well as designed the overall work process, replacing the manual process currently being used.

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Minimized the backup-time, restore-time, disk I/O and storage required for backups with Backup Compression. Performed database and data file backups on all the databases as required.

Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.

Used database consistency checks using DBCC utilities.

Monitor and optimize system performance using SQL Profiler and Activity Monitor

Created and implemented database design solutions in collaboration with programming team.

Improved performance, reliability, security and scalability by improving internal processes and make recommendations on new storage hardware.

Controlled and monitored user access to the databases by implementing security policies.

Provided DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012 environments.

Experienced in using SQL Server Profiler and SQL Server Agent.

Participated in on-call schedule to respond to SQL Server alerts and potential production database issues.

Deployed builds in Production servers for schema changes and worked in CMR(Change Management Request) department.

Over 6 years experience in T-SQL programming i.e. writing Queries, Stored Procedures.

Familiar with Virtualization technology and running Windows inside a Virtual Machine.

Experience in transitional replication both configuration and troubleshooting.

Extensive experience in overhauling improperly designed database schemas including improperly merged entities, improper references between entities, references on the many-side entity failing to reference the full unique key of the one-side entity, and first & second normal form violations.

Capacity planning, Performance tuning, Disaster recovery, trouble shooting backup /restore procedures, Worked with several teams and lead database team in the process of development of a Disaster Recovery and high availability solutions.

Experience with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS

Fluent in SQL Commands for resolving deadlocks and blocking issues.

Monitoring of Performance monitor (perfmon), SQL Profiler for monitoring instances, Debug T-SQL statements, identifies slow running queries.

Experience in working with global clients and handling high priority production issues over Email/phone

Worked as Tier 3 level DB Engineer and Troubleshooting customer escalations and providing solutions to Tier 1 and Tier 2 DB support team.

Domain Expertise:

E-Governance Applications (G2C and G2B)

oBuilding Penalization Scheme (BPS) Url: http://bps.ap.gov.in/

oPaddy Procurement System (PPS) Url: https://pps.telangana.gov.in

oCommissioner ate of School Education (CSE) : Url: http://cse.ap.gov.in/

oCM Office Real Time Executive Dash Board (CORE) Url : http://core.ap.gov.in/

Electronic Fund Management System (EFMS) having 6 yrs experience

Hospital Information System (HIS) having 2 yrs experience

Customer Support having more than 8 yrs experience

Auditing (Both Transactions, Process and Systems) having more than 4yrs experience

Operations (having than 6 yrs experience)

Technical proposals (Having 4 yrs experience)

Education:

Master of Computer Applications from Osmania University completed in 1998.

B.Sc (Mathematics), from Nagarjuna University in 1995.

Certification / Training:

Microsoft Certification in SQL server Database Administration.

Under gone training for Internal Auditor and conducted process audit for more than 10 projects.

Training completed on Technical Documentation and Effective Technical Writing.

Training completed on Integrated Quality Management System (iQMS) Curriculum.

Work Experience:

Currently Working as Sr.DBA Lead forGlobal Data Solutions Inc.

Worked as System Analyst / DBA lead/Project Manager for Tata Consultancy Services.

(07/2004 – 05/2016).

Worked as Sr. Software Engineer /DBA for Citadel Health Ltd(12/99-05/2004).

Technical Skills:

Languages

Visual Basic 4,5 and 6, VB.NET, ASP.NET, HTML, XML

Brief Knowledge not an hands on experience

Operating Systems

Microsoft Windows NT, 2000, 2003,2008R2 and XP

5 Yrs

Databases

MS SQL Server 2000, 2005, 2008R2& 2012

12 Yrs

Applications

MS IIS 4, 5, 6, Personal Web server,PKI

5

Middleware

Methodologies

Other

Handling Operational and management Issues for the Rural e-Seva kiosks of 4500 across AP and Telangana with the team size of 13

Experience in Financial Transactions Reconciliations

As a internal auditor, conducted audits for more than 10 TCS projects

Coordinating with Internal and External System and Financial Audits for APOnline related projects

DB Mentor for more than 10 projects

3

Project Experience:

MITSUI BUSSAN LOGISTICS INC Dallas, TX

Current (From Jun 2016)

Project Lead / Sr.Database Administrator

MITSUI project is an interface to existing application to enhance current process and improve the user experience.

This will enable users to close the Sales Orders automatically from backend to Database, with respect to the data availability through Web Portal reports. Currently users are entering delivered quantities manually in web portal, that Database table(s) update and set as "Closed" to complete the Sales Order process, but it required daily manual intervention. This exercise is to build a Program to upload the "CSV Data" file(s) (instead of manual entry of actual delivered quantity from web portal) to Database Tables. This program should intelligent enough to configurable and identify the columns (data is in any order in uploaded file) and update database automatically.

Enhance existing features using web portal to provide user interface in web with the following new functionality’s

User authentication module

Access privileges based on group authenticity

Detailed tracking and reporting of excess and slow moving inventory

Upstream transportation and logistics coordination, including reverse movements as requested

Transaction enquiry

Transaction verification and settlement among partners

Responsibilities :

Requirement Collection/ Client Interaction

Database Design, Development, Maintenance & Administration

T-SQL Programming

Supervised code review of scripts with developers. Advised developers in code optimization.

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Review of work progress with team

Ensuring on time delivery

Attend Review Meetings with client

Send status reports to client on every 15 days

Handling of CRs

Highlights:

Maintenance of production database objects during release activity

Backup, Reorganization, Point in time recovery of DB2 objects

Designed database, Developed Robust MIS, Graphical Reports.

Handled Team of 8 members.

Resolved Database Performance Issues.

Performance Tuning of Database applications.

Environment: Agile Environment, Java/J2EE, EDI Subsystem BizLink, Windows 2008 server/ SQL 2012 blade server, Tomcat Server, Spring, Hibernate, Angular, REST, Web Services, EDI, SAP, CDC-Hostess, CDC-Perrigo, Web Services, IDOCS, MS Access and UNIX

Mines and Geology Department

Feb 2014 to May 2016

Online Mineral e-Permit System

Tata Consultancy Services

Project Leader and Database Administrator

The objective is, IT enablement of Mines & Geology Department Mineral Permit System to deliver services to Lease Holders.To make it more convenient and transparent, To Increase the productivity of Lessee, To Increase the revenue to Government,Real-time MIS for easy monitoring of service delivery, Online Filling of Mineral Concession Applications, Reconnaissance Permits, Prospecting Licenses, Mining Leases, Granite Quarry Leases, Other Quarry Leases, Marble Quarry Leases.

Responsibilities

Requirement Collection/ Client Interaction

Database Design, Development, Maintenance & Administration

Review of work progress with team

Ensuring on time delivery

T-SQL Programming

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Supervised code review of scripts with developers. Advised developers in code optimization.

Attending Review Meetings with client

Follow-up with clients for work orders and payments

Performance Tuning of Database applications.

Sending status reports to client on every 15 days

Highlights:

Designed database, Developed Robust MIS, Graphical Reports

Implemented Database Log Shipping for Disaster Recovery Site

Handling Team of 16 members

Migration & Maintenance of Huge databases

Resolved Database Performance Issues

Environment: C#.NET, ASP.NET, XML and SQL Server 2008 R2, Windows 2008 R2

MeeSeva (Citizen Services G2C )

http://www.meeseva.gov.in

Nov 2011 to May 2014

Tata Consultancy Services

Project Leader / Database Administrator

Government of Andhra Pradesh has undertaken various initiatives for the NeGP Program and already put in place the APSWAN, AP State Data Center, eSeva Centers, APOnline Centers, and Common Service Centers. To knit all these initiatives together to harness the benefits of the above for the citizens of AP, Government have decided to undertake the initiative called MeeSeva. Through MeeSeva, Government of Andhra Pradesh desires to have the citizen services available incentralized platform and deliver services through all Citizen Service Centers such as eSeva, APOnline & CSCs across the state.

MeeSeva has been providing faster, easier and transparent access to various G2C services through more than 7000 kiosks by utilizing Information & Communication Technologies. It’s an Integrated One Stop Solution for 90 Million Citizens to approach Government for all their pressing needs. The Project brings in a digital PKI enabled integrated architecture to deliver G2C Services in a purely electronic mode (replacing issuing of ink signed paper based manual certificates).

Responsibilities :

Requirement Collection/ Client Interaction

Database Design, Development, Maintenance & Administration

Review of work progress with team

Ensuring on time delivery

T-SQL Programming

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Attending Review Meetings with client

Follow-up with clients for work orders and payments

Sending status reports to client on every 15 days

Handling of CRs

Supervised code review of scripts with developers. Advised developers in code optimization.

Highlights:

Maintenance of production database objects during release activity

Backup, Reorganization, Point in time recovery of DB2 objects

Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.

Designed database, Developed Robust MIS, Graphical Reports.

Implemented Database Log Shipping for Disaster Recovery Site.

Handled Team of 50 members.

Migration & Maintenance of Huge databases.

Resolved Database Performance Issues.

Performance Tuning of Database applications.

Environment: Waterfall, Visual Studio 2008, .Net Framework 3.5, ASP.NET MVC 3.0, ASP.NET, C#, WCF, ADO.Net, SQL Server 2008 R2, Enterprise Library, TFS 2008, JavaScript, JQuery, HTML, CSS, PKI, File Server

Property Tax Management System (PTMS)

Treasurer Tax Collector, County of Orange, Santa Ana, CA

Tata Consultancy Services

Sep 2008 to Jan 2011

Database Administrator

The Project the vision of a Property Tax Management System (PTMS) for the Orange County Treasurer - Tax Collector is to provide Orange County’s Treasurer-Tax Collector’s Office with the tools and means to enhance and improve administration of the Orange County Property Tax programs. The new PTMS will be developed with optimal processes and modern information technology that will improve operations and services for the Orange County taxpayers.

PTMS offers hope to provide a flexible and adaptable technology platform that will be able to keep pace with program requirements and meet the emerging needs of improved services to the taxpayers of Orange County. The PTMS system will be developed in 3 Phases called Tier’s. Tier-1 would have 8 functional modules, Tier-2 would have 6 functional modules and Tier-3 will have 7 functional modules.

Responsibilities :

Requirement Collection/ Client Interaction

Database Design, Development, Maintenance & Administration

Attending Review Meetings with client

Scheduled full, differential, and transactional log backups for user created databases in production environments.

T-SQL Programming

Supervised code review of scripts with developers. Advised developers in code optimization.

Sending status reports to client on every 15 days

Handling of CRs

Highlights:

Maintenance of production database objects during release activity

Backup, Reorganization, Point in time recovery of DB objects

Database tuning, query optimization, Table and Index design and performance benchmarking.

Designed database, Developed Robust MIS, Graphical Reports.

Implemented Database Log Shipping for Disaster Recovery Site.

Migration of PTMS legacy database (DB2) into SQL Server 2008 R2

Resolved Database Performance Issues.

Performance Tuning of Database applications.

Environment: Waterfall, Visual Studio 2008, .Net Framework 3.5, ASP.NET MVC 3.0, ASP.NET, C#, WCF, ADO.Net, SQL Server 2008 R2, Enterprise Library, TFS 2008, JavaScript, JQuery, HTML, CSS

Electronic Fund Management System (EFMS)

Citizen Services (G2C and B2C)

Tata Consultancy Services

Nov 2011 to May 2014

Project Leader / Database Administrator

Enables MeeSeva to transfer user charges, statutory charges, postal charges collected through various MeeSeva kiosks to respective Service Departments, DEGS & ESD accounts.System enables to keep all funds collected through various MeeSeva centre's in one central account in state capital and transfer funds electronically to the respective department accounts at a regular frequency.Once the SCAs transfer the statutory charges collected of various services into their respective accounts, nodal bank transfers these amounts into MeeSeva pooling account.

Once the statutory charges are transferred to MeeSeva pooling account, system generates FTO (Fund Transfer Orders) and sent to nodal bank. odal bank processes all the FTO’s and money is transferred to respective department bank accounts

Responsibilities :

Requirement Collection/ Client Interaction

Database Design, Development, Maintenance & Administration

Review of work progress with team

Ensuring Payment Cycles (Weekly)

T-SQL Programming

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Ensuring Data Correctness pertains payments to be made

Reconciliation of Transaction before processing the payments and Reports.

Ensuring with participated department upon funds received.

Coordinating with bankers for any technical and operational issues which causes delay in payments

Supervised code review of scripts with developers. Advised developers in code optimization.

Attending Review Meetings with client

Follow-up with clients for work orders and payments

Sending status reports to client on every 15 days

Handling of CRs

Highlights:

Maintenance of production database objects during release activity.

Payment approvals with PKI enabled security by respective department officials.

Backup, Reorganization, Point in time recovery of DB2 objects

Database tuning, query optimization, Table and Index design and performance benchmarking.

Designed database, Developed Robust MIS

Implemented Database Log Shipping for Disaster Recovery Site.

Handled Team of 7 members.

Resolved issues between banks and EFMS applications

Performance Tuning of Database applications.

Environment: Visual Studio 2012, .Net Framework 4.5, ASP.NET 4.0,C#, Web API, Entity Framework 5.0, LINQ, SQL Server 2012, TFS 2010, JavaScript, PKI (Public Key Infrastructure), File Server, SFTP

Project Experience : 12+ yrs

Tata Consultancy Services

Citizen Services, Tata Consultancy Services

June 2004 to May 2016

Project Leader and Database Administrator and SQL Developer

APOnline is a gateway for the Government of Andhra Pradesh to offer multiple services, through a single window to the citizens. This is a joint venture between TCS and Government Of AP.The Portal redefines governance and the government-citizen interface. APOnline is comprehensive with more than 200 different services including payment services, form submissions and information’s about the various Organizations of the government

Range Of Services

Information Services: Provide up-to-date information on a wide range of subjects pertaining to different GoAP departments, including Functions & Services, Forms, Key Contacts, Acts, Rules, etc.

Interactive Services: Facilitate online submission of forms, including applications and requests for registrations, licenses, permits, certificates and representations to different government departments. Complaints and grievances can also be filed.

Payment Services: Online payments for utility bills, taxes, fees, deposits and stamp duties

Responsibilities :

Requirement Collection/ Client Interaction

Database Design, Writing Queries and Stored procedures

Testing

Implementation & Deployment

Requirement Collection/ Client Interaction

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Database Administration

Review of work progress with team

Ensuring Payment Cycles (Weekly)

T-SQL Programming

Supervised code review of scripts with developers. Advised developers in code optimization.

Ensuring Data Correctness pertains payments to be made

Reconciliation of Transaction before processing the payments and Reports.

Ensuring with participated department upon funds received.

Coordinating with Internal and external finance department and ensure that payments made and received.

Attending Review Meetings with client

Sending status reports to client on every 15 days

Handling of CRs

Highlights :

Designed database for offline mode application

Implemented desktop application for Rural Service Delivery Points

Have successfully installed application in more than 700 rural kiosks across AP

Migration & Maintenance of Huge databases (Election Data)

Developed and delivered more than 400 services to citizens

Environment: C#.NET, ASP.NET and SQL Server 2008 and Windows 2008.

Family Health Plan Ltd, Apollo Hospitals, Hyderabad.

Benefit Plan Designer

Dec 2000 to May 2004

SQL Server Developer /DBA

Managed Care, Benefit Plan allows for detailed plan definition thus making manual claim processing intervention seldom required. Since it is capable of holding an infinite number of plan definitions, processing is fully automated and resource efficient. Any number of complex benefit plans with different limits and eligibility criteria can be defined and information can be automatically used for adjudicating claims. Benefit Plan utilizes flexible logic that allows you to: Design and formulate virtually unlimited benefit plans that cater to the needs of any type of organization. Apply full details of the plan in the adjudication process. View the macro level and micro level limits of each benefit plan. Define grades for member organization and maximum coverage limits (Out Patient, In-Patient, etc.,) under each grade. Define threshold limits of each benefit covered within a benefit plan. Define micro level details like eligibility limits, procedure exclusions, medication exclusions, inclusions, etc. for a particular benefit plan. Use all the rules attached to the plan and all of the other business Security is given maximum priority and has been implemented

Responsibilities :

Under Standing Requirements

Creation of tables

Writing queries and stored procedures

Environment: C#.NET, ASP.NET and SQL Server 2000

Contact this candidate