Associate Practice Manager - SQL Server DBA
Tricore Solutions
Total years of experience :15 years, 10 Months
Tricore Solutions, New Delhi (April 2008 - till date)
(Associate Practice Manager - SQL Server DBA)
Tricore Solutions LLC., New Delhi April 2008 - Present
Tricore Solutions LLC has been recognized as Oracle's leading partner in the Eastern United States for providing World Class Enterprise Technology Outsourcing and Managed Services solutions, eBusiness Suite Technical and Functional Consulting, Oracle Technology Consulting, Oracle Apps Functional Consulting, Oracle Sales Consulting Services, Business Intelligence Consulting and SQL Server Database Administration.
Project Details
Client: Genomic Health
Description: Genomic Health, a life science company founded in August of 2000, is committed to improving the quality of cancer treatment decisions through the research, development and commercialization of genomic-based clinical laboratory services. To that end, the company conducts sophisticated genomic research to develop clinically-validated molecular diagnostics which provide individualized information on response to certain types of therapy, as well as the likelihood of disease recurrence. These diagnostic technologies generate information that healthcare providers and patients can use in making treatment decisions.
Technologies: SQL Server 2005 and SQL Server 2008, Spotlight for SQL Server, Foglight, EMC Replication Manager, ER Studio, Performance Analysis tool for SQL Server
Role: Primary DBA
Responsibilities: • Production Support
• Scheduling, attending weekly meetings and creating reports.
• Creation and maintenance of databases, schema and schema objects as per design and plan
• Setting up SQL Server and Database security
• Monitoring High Availability
• Replication and Space Monitoring
• Creating and deploying custom scripts for database management
• Promotion of Scripts
• Troubleshooting
Client: IMS Health
Description: IMS plays a central role in advancing global healthcare - revealing the insights within the most comprehensive market intelligence available. IMS Health is one of the largest health care in US and Canada. We provide support on very critical and business oriented production servers. Tricore is providing support on 240+ servers (Production (126), UACC (38), Integration (6), and Development (70)) . We are responsible for all DBA related activities on these servers like performance issue, security issues, releases, SQL Server Installation and backup and recovery strategy.
Technologies: SQL Server 2000, 2005 and 2008, Litespeed and Erwin
Role: Sr. SQL Server DBA
Responsibilities: • Production Support
• Serving as Primary DBA
• Creation and maintenance of databases, schema and schema objects as per design and plan
• Implementation of data models in database and vice-versa using Erwin tool.
• Setting up SQL Server and Database security
• Monitoring High Availability
• Disabled and Failed Jobs
• Analyze the database with no backups since two months report
• Replication and Space Monitoring
• Creation of 2000, 2005 and 2008 maintenance plans
• Conversion to Litespeed (SLS) maintenance plans in 2000, 2005 and 2008 servers
• Promotion of Scripts
• LiteSpeed extraction utility
• Troubleshooting
Remote DBA Team
• Production support
• Serving as DBA for a group of US based accounts
• Installation of Server Alive and Kiwi Client for New Customers
• Installation, Configuration and Maintenance of Monitoring
• Performing Health Check for New Customers
• Installing, Configuring and Tuning SQL Server for the first time, for new customer
• New customer backup strategy integration and test
• Database maintenance plan management
• Critical events SLA management and first response
• Working with the developers and system administrators on architecture changes
• Preparing documentation
• Automation of Daily Database Administration Tasks
• Using SSIS to implement Backup Processes (SQL Server 2005)
• Managing Security
• Replication Setup (SQL-SQL / SQL-Oracle) (SQL Server 2005)
• Log Shipping
• Managing / Installation of SQL Server on a Windows Cluster Environment
• Performance Tuning
o Query Tuning with the help Query Execution Plan and Profiler
o Re-writing SQL Queries using best practices
o Stored Procedure Tuning
o Recommendation on Indices
o Server and Database Level Configuration for performance optimization
o Query tuning using Database Engine Tuning Advisor (in SQL Server 2005)
Previous Organizations:
Fujitsu Consulting India Ltd., Noida (February 2007 - March 2008)
(Senior System Executive)
Fujitsu Consulting India Ltd. February 2007 - March 2008
Fujitsu Consulting India Ltd. has been an innovative provider of IT solutions that address our clients' business needs. The company delivers IT services on the major ERP platforms (SAP, Oracle, and PeopleSoft) and other enterprise solutions, including SCM, Business Intelligence and CRM, as well as eBusiness Solutions across technology platforms. Fujitsu Consulting India Ltd. has 22 office locations in the United States and two development and support centers in India, which were assessed at CMM Level 5.
Project: - Echostar
Senior System Executive
Role and Responsibility
• Worked as Primary SQL DBA from offshore.
• Worked on tickets using HP Open View.
• Monitored Alerts.
• Setup, install & configure MS-SQL 2000/2005 on Windows 2000/2003 platform.
• Creation of databases, schema and schema objects as per design and plan.
• Index optimization, triggers and performance tuning
• Managed Database users and security
• Managed SQL Server replication, log shipping, cluster architecture.
• Backup and Recovery.
• Applied service packs and patches.
Netlink Software Group Pvt. Ltd., Bhopal (February 2006 - January 2007)
(Team Leader)
Netlink Software Group Pvt. Ltd. (CMMI 3 Level) February 2006 - January 2007
Integrated Subscribers Management Services (DISHTV), Noida (January 2004 - October 2005)
(Programmer)
Integrated Subscribers Management Services (DISHTV) January 2004 - October 2005
Integrated Subscriber Management Services is a Part of Essel Group Company. This part of the Company basically dealing in the sale of Direct to Home Technology (DTH) Equipment. There are all in total 10 Million Subscriber to this Technology. Database basically contains Information about the Subscriber, Dealers and Distributors e.g. Renewal, Deactivation, New Subscriptions, Complaints by the Customers, Special facilities for the customers like Video on Demands Services etc.
Database Administration
Role and Responsibility
• Served as an Assistant DBA
• Worked for Dishtv, Zee Telefilms Group Company
• Worked for Integrated Subscriber Management Services that is a Part of Essel Group Company, this part of the Company basically dealing in the sale of Direct to Home Technology (DTH) Equipment, there are all in total 10 Million Subscriber to this Technology
• Worked on database that basically contains Information about the Subscriber, Dealers and Distributors such as Renewal, Deactivation, New Subscriptions, and Complaints by the Customers, Special facilities for the customers such as Video on Demands Services
• Worked on Total 10 Databases having various database size between 40-50 GB
• Worked on 3 Servers such as Online Server, Operational Server (To download data from Online Server), and Reporting Server
MS SQL Server 7.0, 2000
System Development
• Served as a Assistant Programmer with team size of 5 members
• Provided database Assistant
• Participated in creating new modules, reporting and changes in existing modules
• Worked as an Assistant DBA
• Participated in creating and managing SQL Server databases, servers and server groups
• Participated in creating logons, configuring logon permissions, assigning roles, and conducting other security measures
• Participated in managing tables, indexes, and views
• Queried and manipulated data
• Responsible for optimizing and maintaining databases
• Installed, configured and tuned SQL Server databases
• Implemented backup procedures as per the availability and usage of the system
PowerBuilder, MS SQL Server 2000, Windows 2000
Siti Cable Network Ltd., New Delhi (July 1998 - December 2003)
(Assistant)
Employment Details
Siti Cable Network Ltd. (Zee Telefilms Ltd.) July 1998 - December 2003
Siti Cable Network Ltd. was Media/Cable Company has diversified itself in Entertainment. Company was having the 10 Regional Offices and 60 Joint Venture across the India. Online support of SQL server 6.5 databases is provided to the Regional Offices and Joint Venture as well as HO.
System Development
Role and Responsibility
• Served as an Assistant Programmer
• Worked for Siti Cable Network Ltd that was Media/Cable Company has diversified itself in Entertainment
• Worked for Company that was having the 10 Regional Offices and 60 Joint Venture Across the India
• Provided online support of SQL server 6.5 database to the Regional Offices and Joint Venture as well as HO
• Participated in installation, implementation, administration and maintenance of SQL Server Databases 2000
• Designed and created of databases, schema and schema objects as per design and plan, database space management, backup and recovery
• Planned and implemented physical Backup and Recovery strategies for the production database including logical backup and application tuning for optimizing performance, replication of databases as per need
• Restored database in case of crash/ emergencies
PowerBuilder, MS SQL Server 6.5
Netlink Software Group Pvt. Ltd. (CMMI 3 Level) was founded in 1997, by industry experts with wide international exposure. It has been a pioneer for all the SME companies in this region.
System Development
Role and Responsibility
• Served as a Group Leader for a CMMI 3 Level company
• Worked for Netlink Software Group that was founded in 1997, by industry experts with wide international exposure, a pioneer for all the SME companies in this region
• Worked on Total 10 databases having various database size between 15-20 GB
• Worked on various Servers
MS SQL Server 2000
Master of Business Administration in Project Management (Sikkim Manipal University)
Bachelor of Commerce (Pass) (Delhi University)