Syed Momina

MS SQL SERVER DBA

Email: adkn9l@r.postjobfree.com

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 5.10 Years of total experience in Production, Devel and Test environment SQL Server Database Administrator in 2005, 2008, 2008R2 2012, 2014 & 2016.

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.

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.

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 Consultant - SQL Server Database Administrator for Capgemini, Bangalore, since June 2019 to till now.

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. CERTIFICATIONS

MCTS (70-432) -Microsoft Certified Technology Specialist in Microsoft-SQL Server 2008-Implementation

& Maintenance.

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 and TSM. PROJECTS:

Project #4:

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

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 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.

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 Non Production 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