Sql Server Database Administrator
Resume:
- * -
Syed Momina
MS SQL SERVER DBA
Email: ************@*****.***
Mobile: +91-917*******
CAREER OBJECTIVE:
To take up a challenging career in the emerging SQL Server Database Administration field where I can use my skills, knowledge, talent, hard work, and determination would make my organization and me as successful.
PROFESSIONAL SUMMARY
Having 8.4 Years of total experience in Production, Dev and Test environment SQL Server Database Administrator in 2005, 2008, 2008R2 2012, 2014 & 2016.
Basic experience in Azure Database in providing access to the users, Worked on DTU increasing, Azure migrations.
Experience in Implementation, Installation, Configuration and Administration of SQL Server 2005 and 2008, 2008R2, 2012, 2014 and 2016.
Experience in Remedy ticketing tool to provide the resolution based on the SLA.
Participate daily DBA statues call meeting and follow-up with pending tickets, Changes and tasks.
Participate weekly Change review meeting and get the approvals for the changes.
Applying Service Packs and Hot fixes in different versions 2005, 2008, 2008R2, 2012 & 2014.
Experience in Different types of Backups and Restoration types based on the recovery models
Experience in configure different types of Replication and trouble shooting.
Experience in Configure Database Mirroring, monitoring and Failover.
Experience in Implement and maintain Database Security (Logins, Roles, permissions).
Experience in Migration activity from SQL Server 2005 to 2008/2012.
Experience in scheduled Jobs, Tasks, Alerts and Maintenance Plans.
Experience in adding space on standalone database, principal and mirror databases.
Basic experience in Encryption (Native Encryption) and DB Security
Monitoring Disk Space of all the Servers and shrink the data and Log files.
Experience in performance tuning like server level and query level.
Troubleshooting Blocking, Log file full and tempdb full issues.
Sound Knowledge in Log shipping configuration and implementation.
Experience in Clustering, installation, apply service pack, failover and troubleshooting
Effective usage of DBCC Commands & DMV’s ensuring integrity of the databases.
Working experience on AlwaysON in 2012, configuration and troubleshooting.
- 2 -
Work experience in a fast-based environment with developers and support staff.
A team player with excellent communication, analytical and interpersonal skills.
Providing 24x7 technical database supports for SQL Database systems. WORK EXPERIENCE
Working as Technical Lead - SQL Server Database Administrator for Wipro Technologies from April 10th 2021 to till now
Worked as Consultant - SQL Server Database Administrator for Capgemini, Bangalore, since June 2019 to July 23rd 2020.
Worked as an SQL Server Database Administrator for Quality Power, Bangalore, since Sep 2018 to May 2019.
Worked as Jr.SQL Server Database administrator for Hardwin software solutions, Bangalore, from May 2014 to Aug 2018.
EDUCATIONAL PROFILE
Bachelor of Technology (B-Tech) in Computers science and Engineering from J.N.T.UUniversity in 2012. TECHNICAL ENVIRONMENT
RDBMS MSSQL Server 2005/2008/2008R2/2012/2014 & 2016. Languages C, C++, Java, T-SQL
Operating Systems Windows 2003/2008/2012 and 2016 Servers. Commercial Applications Ms Office
SQL Servers Tools SSMS, SQL Profiler, DETA, Cherwell, Remedy, SNOW, Foglight, Spotlight, CommVault and TSM.
PROJECTS:
Project #8:
Name : Levis Strauss&Co
Client : USA, UK, INDIA.
Environment : SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016, 2017,2018 Operating System : Windows 2008, 2008R2 & 2012.
Role : Consultant Database Administrator
Team Size : 11
Description: Levi Strauss & Co. is an American clothing company known worldwide for its Levi's brand of denim jeans. It was founded in May 1853 when German-Jewish immigrant Levi Strauss moved from Buttenheim, Bavaria, to San Francisco, California, to open a West Coast branch of his brothers' New York dry goods business.
Roles & Responsibilities:
Work experience in refresh activities and per change request.
Experience in resolving blocking issues, performance issues on daily basis.
- 3 -
Experience in doing capacity planning for all the prod and non-prod servers to increase the space on drives before doing refresh activities.
Installation and Configuration of SQL Server 2005, 2008, 2008R2 and 2012.
Applied services packs (patches) for SQL Server 2005, 2008, 2008R2 and 2012.
Migration of databases from SQL Server 2005 to SQL Server 2008.
Responsible for creating Logins, Users and Assigning database Permissions
Monitoring the temp db full and transactional log full issues.
Installing the SQL server 2005/2008 R2 /2012 and applying the service packs.
Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
Maintaining the replication and troubleshooting the replication issues.
Daily checking the tickets assign the tickets and resolve the tickets depends on the priority levels.
Daily monitoring the DB space Management issues and allocating the required space to databases.
Databases refresh activities from SQL server 2005 to SQL server 2008/2008/R2. Project #7:
Name : Grant Thornton
Client : USA, UK.
Environment : SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016, 2017,2018 Operating System : Windows 2008, 2008R2 & 2012.
Role : Consultant Database Administrator
Team Size : 10
Description: Grant Thornton LLP is the American member firm of Grant Thornton International, the seventh largest accounting network in the world by combined fee income. Grant Thornton LLP is the sixth largest U.S. accounting and advisory organization. The firm operates 59 offices across the US with approximately 8,500 employees, 550 partners, and produces annual revenue in excess of US$1.9 billion. Roles & Responsibilities:
Work experience on Azure portal in creating logins and permissions, DTU monitoring and increasing, We will check timeout issues as per the error occurred to the user at particular time frame.
Work experience in SSIS packages.
Work experience in refresh activities and per change request.
Experience in application work as well in in vertex server fixing the errors and adding new clients to the database as per vendor request.
Installation and Configuration of SQL Server 2005, 2008, 2008R2 and 2012.
Applied services packs (patches) for SQL Server 2005, 2008, 2008R2 and 2012.
Migration of databases from SQL Server 2005 to SQL Server 2008.
Responsible for creating Logins, Users and Assigning database Permissions
Monitoring the temp db full and transactional log full issues.
Installing the SQL server 2005/2008 R2 /2012 and applying the service packs.
- 4 -
Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
Maintaining the replication and troubleshooting the replication issues.
Daily checking the tickets assign the tickets and resolve the tickets depends on the priority levels.
Daily monitoring the DB space Management issues and allocating the required space to databases.
Databases refresh activities from SQL server 2005 to SQL server 2008/2008/R2.
Managing server disk space and maintaining backups with support of TSM team.
Maintaining the replication and troubleshooting the replication issues.
Configure the transaction replication and mirroring when client required.
Rebuilding the indexes at regular intervals for better performance. Project #6:
Name : Forterra UK and US
Client : USA, UK.
Environment : SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016, 2017,2018 Operating System : Windows 2008, 2008R2 & 2012.
Role : Consultant
Team Size : 11
Description: Forterra is a leading UK manufacturer of essential clay and concrete building products, with a unique combination of strong market positions in clay bricks, concrete blocks and precast concrete flooring. We are experts in creating the bricks, blocks, precast concrete, paving and many other vital products and services that are Keeping Britain Building.
Roles and Responsibilities:
Strong experience in Database Administration in SQL Server (2008, 2008r2,2012,2014,2016)
Take cares in troubleshooting and resolving database Integrity Issues, Performance Issues, Blocking and Deadlocking Issues, Log Shipping Issues, Connectivity Issues, Security Issues
Take cares Performance Tuning and Optimization (PTO), using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
Detect and troubleshoot SQL Server related CPU, Memory, I/O, Disk Space and other resource contention
Responsible for High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server such Replication, Failover Clustering, Always on High availability
Take care how indexes, index management, integrity checks, statistics work, how indexes are stored, how they can be created and managed effectively
Knowledge of SQL Server tools (Profiler, SSMS, Configuration Manager, Perfmon, DMV’s, system procs)
Installation & configuration of SQL Server 2008/2008 R2/2012/2014/2016 standalone and Cluster environment (Active-Active \Active -Passive)
Fixing Orphaned users through stored procedures.
- 5 -
Project #5:
Name : T- Mobile
Client : USA, UK, India.
Environment : SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016, 2017,2018 Operating System : Windows 2008, 2008R2 & 2012.
Role : Consultant
Team Size : 11
Description: T-Mobile U.S. traces its roots to the 1994 establishment of Voice Stream Wireless PCS as a subsidiary of Western Wireless Corporation. After its spinoff from parent Western Wireless on May 3, 1999, Voice Stream Wireless was purchased by Deutsche Telekom AG in 2001 for $35 billion and renamed T- Mobile USA, Inc, in July 2002. In 2013, T-Mobile and MetroPCS finalized a merger of the two companies which started trading as T-Mobile U.S.
Roles & Responsibilities:
Strong experience in Database Administration in SQL Server (2008, 2008r2,2012,2014,2016)
Taken care of Reboot activities every month for Prod Servers.
Take cares in troubleshooting and resolving database Integrity Issues, Performance Issues, Blocking and Deadlocking Issues, Log Shipping Issues, Connectivity Issues, Security Issues
Take cares Performance Tuning and Optimization (PTO), using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
Detect and troubleshoot SQL Server related CPU, Memory, I/O, Disk Space and other resource contention
Responsible for on backups, restores, recovery models, database shrink operation, DBCC commands, Database Mirroring
Responsible for High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server such Replication, Failover Clustering, Always on High availability
Take care how indexes, index management, integrity checks, statistics work, how indexes are stored, how they can be created and managed effectively
Knowledge of SQL Server tools (Profiler, SSMS, Configuration Manager, Perfmon, DMV’s, system procs)
Worked on SQL server License Manager.
Installation & configuration of SQL Server 2008/2008 R2/2012/2014/2016 standalone and Cluster environment (Active-Active \Active -Passive)
Fixing Orphaned users through stored procedures
Migration/Up gradation of SQL Server from 2008/2008 R2/2012/2014/2016.
Applying SQL Server Hot fixes, patches & Service packs.
Creating and scheduling Jobs
Project #4:
- 6 -
Name : Carnival
Client : USA, UK, India.
Environment : SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016. Operating System : Windows 2008, 2008R2 & 2012.
Role : B2 Consultant
Team Size : 9
Description:
Carnival Cruise Line is proud to be part of a family of companies owned by Carnival Corporation, which Includes sisterlines Princess Cruises, Holland America Line and Cunard Line, among others. In a nutshell… we’re all about fun vacations at sea and ashore! A Carnival cruise features day and nighttime entertainment like stage shows, musical performances, deck parties, casinos and more. (Like waterslides) We invite our guests to come as they are, and we make everyone feel right at home with comfy staterooms, attentive service, casual and elegant dining, plus a variety of bars and gathering places indoors and out. Guests enjoy this unique experience against the backdrop of some of the world’s most beautiful seaports. Our 28 ships operate 2- to 17-day voyages, departing from every coast in the U.S., as well as Canada, Puerto Rico and Barbados. While we’re best known for Caribbean cruises, we sail to other exotic and amazing destinations like Mexico, Alaska, The Bahamas, Europe and Hawaii. Additionally, Carnival Cruise Line Australia has two ships, and offers cruises from Sydney and Brisbane to New Zealand and the Pacific Islands. Roles & Responsibilities:
Installation and Configuration of SQL Server 2005, 2008, 2008R2 and 2012.
Applied services packs (patches) for SQL Server 2005, 2008, 2008R2 and 2012.
Migration of databases from SQL Server 2005 to SQL Server 2008.
Responsible for creating Logins, Users and Assigning database Permissions
Monitoring the temp db full and transactional log full issues.
Installing the SQL server 2005/2008 R2 /2012 and applying the service packs.
Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
Maintaining the replication and troubleshooting the replication issues.
Daily checking the tickets assign the tickets and resolve the tickets depends on the priority levels.
Daily monitoring the DB space Management issues and allocating the required space to databases.
Databases refresh activities from SQL server 2005 to SQL server 2008/2008/R2.
Managing server disk space and maintaining backups with support of TSM team.
Maintaining the replication and troubleshooting the replication issues.
Configure the transaction replication and mirroring when client required.
Rebuilding the indexes at regular intervals for better performance. Project #3
Name : Inavitas Solar.
Client : Australia, USA, India and Turkey.
Environment : SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016. Operating System : Windows 2003/2008 & 2012.
Role : SQL Database Administrator.
Team Size : 4
- 7 -
Description:
In our ever-changing world, T4E is here to equip customers with rapid and flexible solutions, giving them complete control over their energy expenditure. With our top-of-the-line Energy Management Systems
(EMSs), homeowners and business owners alike can monitor, analyse, and optimise their energy production and consumption. Inavitas Solar is providing a complete management system for solar power plant operators and investors. Inavitas Solar, whose backbone is based on Inavitas T&D being used in 18 DSOs, has been developed with a flexible architectural approach, allowing not only solar power plants, but also other renewable energy resources to be managed from a single platform Roles & Responsibilities:
Installation and Configuration of SQL Server 2005, 2008, 2008R2 and 2012.
Applied services packs (patches) for SQL Server 2005, 2008, 2008R2 and 2012.
Migration of databases from SQL Server 2005 to SQL Server 2008.
Responsible for creating Logins, Users and Assigning database Permissions
Monitoring the temp db full and transactional log full issues.
Installing the SQL server 2005/2008 R2 /2012 and applying the service packs.
Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
Maintaining the replication and troubleshooting the replication issues.
Daily checking the tickets assign the tickets and resolve the tickets depends on the priority levels.
Daily monitoring the DB space Management issues and allocating the required space to databases.
Databases refresh activities from SQL server 2005 to SQL server 2008/2008/R2.
Managing server disk space and maintaining backups with support of TSM team.
Maintaining the replication and troubleshooting the replication issues.
Configure the transaction replication and mirroring when client required.
Rebuilding the indexes at regular intervals for better performance.
Work as part of a team and provide 24 x7 supports when required Project# 2:
Name : Dashboard.
Client : AT&T USA.
Environment : SQL Server 2005, 2008, 2008R2 & 2012. Operating System : Windows 2003/2008 & 2012.
Role : Associate Database Administrator.
Team Size : 5
Description:
CCTP is an AT&T Enterprise initiative to support the strategy of a common desktop application solution across AT&T Consumer and BCS (Business Communication Services) Markets. Both Consumer and small-end BCS Market sponsor CCTP in West and South West Regions in US. The primary business objective is to present data from a variety of systems (BOSS, SORD etc.) in a way that will make the Service
- 8 -
Representative’s job easier and more efficient. Our SQL Server team provides database administration for all applications that use SQL Server as backend.
Roles & Responsibilities:
Installation and Configuration of SQL Server 2005, 2008, 2008R2 and 2012.
Applied services packs (patches) for SQL Server 2005, 2008, 2008R2 and 2012.
Migration of databases from SQL Server 2005 to SQL Server 2008.
Responsible for creating Logins, Users and Assigning database Permissions
Installing the SQL server 2005/2008 R2 /2012 and applying the service packs.
Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
Maintaining the replication and troubleshooting the replication issues.
Maintaining Mirroring and troubleshooting the mirroring issues.
Troubleshooting transaction logs and temp DB when full.
Scheduling of backup Jobs (Daily & Weekly) as per the client request.
Configure the transaction replication and mirroring when client required.
Rebuilding the indexes at regular intervals for better performance.
Regular checking of the database consistency using DBCC commands to minimize complexity.
Work as part of a team and provide 24 x7 supports when required Project: 1
Project Title : Centra View
Client : CBM Software & Services Pvt, Ltd.
Operating System : Windows 2003/2008 EE
Database : SQL Server 2005, 2008 & 2008R2
Role : Jr. SQL Database Administrator
Team size : 4
Description:
Centra View is Centralized Business Management (CBM) software and services Company. It has many CBM software products and it also provides services to its clients. We have internally two teams to support SQL Server and MySQL. Our SQL Server team provides database administration for all applications that use SQL Server as backend. We perform database monitoring and ensure high availability of database(s) and hence-forth the applications.
Roles & Responsibilities:
Daily involved statues call meeting and follow-up with pending tickets.
Weekly involved change CAB Meeting and get the approval of Changes.
Installing, Configuring of SQL Server 2005 & 2008 and 2008R2 on Local System and Remote systems
Day-to-day activities like taking backup on disk and restore the databases and transaction log on production/development servers as per requirement.
Database Refresh activity form Production server to test/ UAT server.
Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes.
- 9 -
Monitoring SQL Server Jobs and Troubleshooting on failure.
Rebuilding the indexes at regular intervals for better performance.
Configuring, Implementation and Trouble Shooting Transactional Replication.
Migration of Databases from NonProduction to Production, Vice Versa.
Hands of experience in Configuring the Database Mirroring.
Maintaining the replication and troubleshooting the replication issues.
Maintaining Mirroring and troubleshooting the mirroring issues.
Applying patches to Test/Devil/Productions servers.
Monitoring the tempdb full and transactional log full issues.
Work as part of a team and provide 24 x7 supports when required.
[Syed Momina]
Contact this candidate