Sql Server Database Administrator

Ayub Mohammed, Database Administrator

Email: ****.*****@*****.***

Mobile No: 872-***-****

SUMMARY

Having 3+ years of work experience in Database Administration which includes MS SQL Server 2016, 2012 & 2008 in production and development environments. Experienced in Database Backup, Restore, Recovery and Disaster Recovery procedures and implementing a perfect backup strategy for the organization.

Completed Master’s in Computer Science from Governors State University, Chicago, Illinois (Jan 2016 - Aug 2017) with a GPA of 3.3 out of 4.0. I have done various project during my coursework, the one which is most prominent is developing a Sales Management portal & creating a Database for Han Academy so they can sell their courses to the students & handle the information of the students.

Done my Bachelor’s degree in India from Jawaharlal Nehru Technological University, Hyderabad in Electronics & Communications Engineering with a GPA of 3 out of 4.

TOOLS & SKILLS:

Languages : T-SQL, SQL, C & C++.

Databases : MS SQL Server 2016/2012/2008, PL/SQL.

SQL Server Tools : SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data tools, SQL Profiler, Tableau & SQL Query Analyzer.

Data Modelling Tools: MS Excel & MS Visio.

Web : HTML, CSS, JavaScript and XML.

Other : MS Word, MS Access, MS Power Point and MS Outlook.

WORK EXPERIENCE

Wipro Technologies (Hyderabad, Telangana) July 2013 – Dec 2014

JOB TITLE: Junior SQL Server Database Administrator

RESPONSIBILITIES:

Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Creating Databases and database objects such as Tables, Views, Triggers, Indexes and Stored Procedures in Development and Production environments.

Performed Database maintenance activities like Backups, Restoring, and Re indexing etc.

Performed Full Backups and Transaction Log Backups. Restored them whenever necessary, creating back up strategies and scheduling them for execution.

Resolving various performance issues by running DBCC commands.

Monitored servers regularly, which includes Backup Job Monitoring and troubleshooting all the issues on regular basis.

Implementing High availability solutions (setting up replication, log shipping, Cluster installation) &Scheduling SQL Server Agent jobs.

HCL Technologies (Hyderabad, Telangana) Jan 2012 – June 2013

JOB TITLE: SQL Trainee Intern

Worked with a team of three experienced SQL Database Administrators as an intern to gain in-depth knowledge of SQL, Unix and Oracle Database.

RESPONSIBILITIES:

Created database objects such as tables, views, stored procedures, Triggers etc.

Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Identifying columns for Primary Keys in all the tables at the design time and create them.

Creating documentation and uploading them in SharePoint

Design indexes for existing applications, choosing when to add or remove indexes.

Assisted and supported issues related to the queries and database systems.

Monitored and provided front-line support of daily processes.

Teaching Assistant Jun 2011 – Dec 2011

Department of Computer Science

Teaching and assisting students/juniors in Electronics & Computer science related subjects.

Grading, Conducting LABS, Preparing Assignments and Exams.

Developed ad-hoc reports using department reporting tools to conduct data analysis.

Data Analysis using SPSS software.

Performing quality analysis to the reports before sending them to the respective firms.

Assisting faculty in developing dynamic online applications, management and hiring actions.

Maintaining department portal and upgrading it to the standards consistently.

Involved in various college application development life cycle.

Closely worked with head of the department in testing the web application tools before bringing into the department.

Academic Projects

Governors State University

University Park, IL

Sales Management Portal

Project Lead in the team of 4 Members

Helped HAN Academy by developing a sales management portal and managing their database, so they can sell their courses to the students and prospective learners in the community. This portal was developed using open source technology including JAVA, c++, PHP, MOODLE, SALE PORTAL, LMS, MS SQL 2012, XAMPP.

MS SQL Database for a IT resource company

Created an online Book rental Library Using .Net Framework 3.5, ASP, CSS, MS SQL SERVER 2016, HTML & Microsoft Visual Studio 2015

• Designed, Developed and Implemented the project in class.

• Worked with the team of 4 Members.

MS-Access Database for Wedgewood Pacific Corporation

The project was to design and implement a database using Access 2016 for Wedgewood Pacific Corporation (WPC). It included Database designing (Database Model), Creating a database, queries, forms and reports.

Contact this candidate