Resume

Sign in

Sql Server Customer Support

Location:
Jacksonville, Florida, United States
Salary:
110000
Posted:
November 28, 2016
Email:
acxn96@r.postjobfree.com

Contact this candidate

SRIDHAR BABU TELLA

Email: acxn96@r.postjobfree.com Mobile: (904)- *** ****

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



Contact this candidate