SRIDHAR BABU TELLA
Email: acxn96@r.postjobfree.com Mobile: (904)- 250 9961
Experience:
15+ years expertise as Senior DBA in Microsoft SQL Server 2012/2008R2/2005/2000 7.0 management and performance tuning, Disaster Recovery, System analysis, Design, deployment, SSRS,SSIS and experience on development. Over7+ 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:
Managing largest size of 5 TB processing more than 3 million transactions per day and automated most of the jobs to cut the high management cost and increased productivity.
Expertise in Troubleshooting, Installation, configuration, Backup /recovery, database security, Data Transformation Services (DTS), Database design, query optimization, Security administration, Replication, mirroring, log shipping and clustering.
Having Experience in migration of database versions from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/SQL 2014 versions.
Experience with Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment.
Worked with the application development teams throughout the development life cycle.
Over 6 years experience in T-SQL programming i.e. writing Queries, Stored Procedures.
Analyse the transactions trend on regular intervals and provide the reports on the same to management so as to take the preventive measures about the infrastructure.
Familiar with Virtualization technology and running Windows inside a Virtual Machine.
Experience in using DMV and dynamic management functions for finding out long running queries.
Experience in handling windows server 2003/2008 administrative tasks like User Administration, patches and hot fix implementation, Security policy, Monitoring Application Event log for any errors, Monitoring Disk space, CPU Memory, Creation of tasks, scheduling using Task Scheduler and monitoring using event viewer.
IIS Maintenance and monitoring in windows servers.
Utilization, log files and taking preventive measures by automating wherever there is a possibility.
Good Understanding on implementation of Agile Methodologies and other project management frameworks.
Able to handle in architectural capabilities in building a SQL Server Architecture solution to handle large volumes of data.
Conducting periodical SQL server process audits at configuration level as well functional level and submit the reports across development team and management team follow up with the concerned team to ensure the defined compliance process is executed as per the time lines.
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.
Having good expereince in Technical team management including offshore team members.
Experience in disaster recovery, performance tuning, and migration from SQL Server 2000 to 2005, 2005 to 2008 and 2008 to 2012.
Expertise in configuring and maintaining SQL Server Active/Active, and Active/Passive cluster.
Configured Always-On High Availability and maintained SQL Server 2012 and Windows 2012.
Taken Preventive measures to avoid SQL Injection and handling the situations if any.
Expertise in configuring and maintenance of Replication Technologies (Snap Shot and Transaction Replication)
Monitoring: Disk space, log space, publishers latency, waits, index fragmentation and generating all the reports.
Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication.
Capacity planning, Performance tuning, Disaster recovery, trouble shooting backup /restore procedures
Expertise in using ETL tools DTS and SSIS, Batch processes, Import, Export, Backup.
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: Idera, 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.
Effectively Handled the 24X7 production and customer support team by analysing the CRs/ Tickets /incidents and assigning to self and team for ensure the issues are closed in the defined intervals.
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:
Developing and Implementing Web Applications With Microsoft Visual C# and Microsoft .Net Framework - SR1660472
Developing XML Web services and Server components with Microsoft Visual C# and Microsoft .Net Framework – SR1660472
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:
Worked as Sr.DBA Lead for Mitsui Bussan Logistics Ltd.
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
SOAP, Web Services, Java Script
Methodologies
1. Water fall Methodology 2. Agile Methodology
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
Tools
SSMS (SQL Server Management Studio)
SSRS (SQL Server Reporting Services)
Informatica (ETL)
Red Gate Tools
SQL Server Profiler
Windows Performance Monitor
Active Monitor
Project Experience:
MITSUI BUSSAN LOGISTICS INC, Dallas, TX
Jun 2016 to Sep 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.
Handling of DB team with the size of 4.
Database Design, Development, Maintenance & Administration.
Query optimization and Index Tuning.
Database Migration from 2008R2 to SQL 2012.
User Management and Access control as part of security.
Configured Backup strategy with Full, deferential and Transaction Log Backups.
Configured SQL Jobs as per the business logic and monitoring of the same.
Created intermediate tables in order to generate the consolidated reports as per the client requirements.
Performance monitoring using tools likes performance monitor and SQL Profiler.
Generation of Traces and diagnose the same in order to find out the performance bottle necks
Configured Transaction Replication for high availability.
T-SQL Programming
Coordinating with develop team in terms of developing queries, stored procedures.
Monitoring Block and locks and resolved the issues.
Taken preventive measures in order to avoid performance issues.
Review of work progress with team
Ensuring on time delivery
Attending Review Meetings with client
Sending status reports to client as mutually agreed.
Handling of CRs
Involved in 24X7 production and customer support.
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
Developed database applications in order to update the mineral rates as and when changes and accordingly calculating the payable and refundable amounts to the lease holders.
Developed Electronic find management system (EFMS) and integrated the same with designated banks and treasury department and payable departments.
Configured SQL Jobs in order to maintain the closing and opening balances of Lease holders on a daily basis.
Continues Monitoring of payments (Successful and Failures) with the bank and processing of Refunds into the end user bank accounts towards failures.
Involved in development of PKI authentication in order to process the payments to various department in a secured mode.
Periodical Review of work progress with the team.
Visiting client locations in order to address the issues in real time being faced in the end user locations.
Configured SQL Jobs as per the business logic and monitoring of the same.
Monitoring Block and locks and resolved the issues.
Taken preventive measures in order to avoid performance issues.
Handling team of 16 members includes development, DBA, Testing and Domain team.
Implemented Backup Strategy and monitoring the same.
Made a practice of BCP (Business Continuity Plan) for every 30 days in order to ensure the verification of backups by restoring the same in DR environment.
Updating patches and service packs as and when needed with the coordination of windows admin team by taking the downtime approval with the client.
Ensuring on time delivery of the work.
User Management and Access control as part of security.
Configured SQL Cluster (Active – Passive) to ensure the availability.
T-SQL Programming
Attending Review Meetings with client
Follow-up with clients for work orders and payments as per the mile stones.
Review of database objects before moving into production.
Performance Tuning of Database applications.
Sending status reports to client on every 15 days
Handled Customer Support and Production Support Team in 24X7 mode.
Environment: C#.NET, ASP.NET, XML and SQL Server 2008 R2, Windows 2008 R2
MeeSeva (Citizen Services G2C )
Electronic Fund Management System (EFMS)
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, eSevaCenters, APOnlineCenters, 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).Cargo – provides information about the shipment and goods.
Responsibilities :
Requirement Collection/ Client Interaction
Database Design, Development, Maintenance & Administration.
Involved in development of web services to connect various Govt departments in order to service the customer needs.
Developed Electronic find management system (EFMS) and integrated the same with designated banks and treasury department and payable departments.
Configured database alerts like SMS, Email in order to send the alerts on failures of SQL maintenance and customised jobs.
Continues Monitoring of payments (Successful and Failures) with the bank and processing of Refunds into the end user bank accounts towards failures.
Involved in development of PKI authentication in order to process the payments to various department in a secured mode.
Configured SQL Jobs as per the business logic and monitoring of the same.
Monitoring Block and locks and resolved the issues.
Taken preventive measures in order to avoid performance issues.
Handling team of 50 members includes development, DBA, Testing, Domain team and customer support.
Updating patches and service packs as and when needed with the coordination of windows admin team by taking the downtime approval with the client.
Ensuring on time delivery of the work.
Developed various applications implementing the dynamic changes in the database.
Made a best practice of BCP (Business Continuity Plan) for every 30 days in order to ensure the verification of backups by restoring the same in DR environment.
Migration & Maintenance of Huge databases from SQL 2005 to SQL 2008.
Database tuning, query optimization, Table and Index design and performance benchmarking.
User Management and Access control as part of security.
Review of work progress with team
T-SQL Programming
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 and customer support in 24X7 mode.
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.
Created database Logical and physical models by using the Embarcadero tool.
Database Design, Development, Maintenance & Administration based on the proto types designed by development team.
Created database maintenance plans like Backups, Index Optimization and update statistics.
Assisting development team in terms of reviewing and optimising the queries and stored procedures written by them.
User Management and Access control as part of security.
Configured database alerts (SMS and Email) on failures of SQL Jobs, Maintenance plans.
Implemented CDC (Change Data Capture) as part of SQL Audit.
Preventive measures taken to avoid SQL injection.
Configured SQL server Cluster (Active – Passive) as part of High Availability.
Developed DTS packages for importing crucial data from several formats like Excel, Text and MS-Access.
Migrated database from DB2 (Legacy Data) into SQL 2008 R2.
Attending Review Meetings with client
T-SQL Programming
Sending status reports to client on every 15 days
Handling of CRs
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
Feb 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
Implemented Backup strategy (Full and Transaction Logins).
Periodical maintenance of update statistics, Index Rebuild and Index Defragmentation.
Continues monitoring of Payment files which are being processed through secured FTP between Financial Department and Banks.
Daily, Weekly and Monthly reconciliation of financial transactions in order to verify the correctness of the transactions data.
Ensuring Data Correctness pertains payments to be made.
Involved in development and implementation of PKI authentication in order to process the payments to various department in a secured mode.
Provided Digital Token and along with digital certificates (PKI) to Department Officials for approving and process the payments to participated departments.
Implemented transaction replication with report server.
Configured Clustered (Active – Passive) environment for disaster recovery.
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.
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 and provided 24X7 customer support.
Having periodical meetings with designated banks and departments to review the payments mechanism and enhancements need to be developed to make the system robust.
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
July 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 OfAP.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, Development, Maintenance & Administration.
Involved in development of web services to connect various Govt departments in order to service the customer needs.
Handled database of more than 30 Govt department databases.
Developed Electronic find management system (EFMS) and integrated the same with designated banks and treasury department and payable departments.
Configured SQL Jobs in order to maintain the closing and opening balances of Lease holders on a daily basis.
Configured database alerts like SMS, Email in order to send the alerts on failures of SQL maintenance and customised jobs.
Continues Monitoring of payments (Successful and Failures) with the bank and processing of Refunds into the end user bank accounts towards failures.
Involved in development of PKI authentication in order to process the payments to various department in a secured mode.
Configured SQL Jobs as per the business logic and monitoring of the same.
Monitoring Block and locks and resolved the issues.
Taken preventive measures in order to avoid performance issues.
Handling team of 35 members includes development, DBA, Testing, Domain team and customer support.
Updating patches and service packs as and when needed with the coordination of windows admin team by taking the downtime approval with the client.
Ensuring on time delivery of the work.
Developed various applications implementing the dynamic changes in the database.
Made a best practice of BCP (Business Continuity Plan) for every 30 days in order to ensure the verification of backups by restoring the same in DR environment.
Migration & Maintenance of Huge databases from SQL 2005 to SQL 2008.
Database tuning, query optimization, Table and Index design and performance benchmarking.
User Management and Access control as part of security.
Review of work progress with team
T-SQL Programming
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 and customer support in 24X7 mode.
Migration & Maintenance of Huge databases (Electoral Data Base)
Trained more than 700 rural kiosks on usage of computer and applications spread across the state.
Initially rolled out the windows application (EXE) for all the kiosks with the synchronization mechanism for every 50 transactions with the central database server.
Converted Windows applications into web applications in a speedy manner with the coordination of development team.
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 Jun 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