Sql Server Real Estate

Mufti Ali

*** ******** ** **, ********** DC *****

************@*****.*** +1-240-***-****

EDUCATION/ CERTIFICATION

• Microsoft certified Implementing and Maintenance SQL Server™ 2012, Dubai (2013)

• Real Estate Regulatory Agency, Phase II, DLD Certified. Dubai (2011)

• Real Estate Regulatory Agency, Phase I, DLD Certified. Dubai (2010)

• Microsoft certified Implementing and Maintenance SQL Server™ 2008. Dubai (2009)

• Marketing Management Degree Addis Ababa (2008)

SUMMERY OF QUALIFICATIONS

I have 5 years of professional experience in Database design, development and administration of MS SQL

servers in Production, QA, and Development Environments.

Expertise in Database Administration on production servers with server configuration, performance tuning

and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective

documentation and specification.

Administering SQL server High Availability and Disaster Recovery strategies.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, contained

Database, Security principals and AAG.

Experience in Using DMV and DMF for finding out long running Query.

Worked extensively on clustering and server consolidation. Troubleshooting production issues and rising

high availability.

Proficiency and experience in SQL Server Replication, Backup/Recovery, Disaster Recovery and Planning.

Having hands on experience in DR processes including Log shipping and Database Mirroring.

Handled Multiple SQL Instances on cluster environment for server consolidation projects built on SAN

using RAID levels.

Worked on configuration SQL Server with minimum privileged.

Worked on SQL Server migration 2012 from SQL Server 2008 and 2005.

Experience in batch processes, Import, Export, Backup, Database Mirroring tools and Application support.

Having experience on data center server and handling 1.1TB Databases.

Certified SQL Server 2008/2012 Associate.

Excellent Communication and Interpersonal Skills.

24x7 Production Database on Call Support.

SKILLS

• SERVER OPERATING SYSTEM: WINDOWS 2003,WINDOWS 2008, WINDOWS 2012

• PROGRAMMING LANUGUAGE: T-SQL

• RDBMS: SQL SERVER 2005/2008/2008 R2/2012

• PERFORMANCE TOOLS: PROFILER, TUNING ADVISOR, SYSTEM MONITOR, DMV.

• IDE: SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO, SSMS, EN TERPRISE MANAGER,

QUERY ANALYZER, EXPORT/ IMPORT (DTS).

Mufti Ali

724 Hamilton St NW, Washington DC 20011

************@*****.*** +1-240-***-****

WORK EXPERIENCE

(April 2013 –December 2014)

Database Administration

United SEO Dubai, UAE

Responsibilities:

Monitoring the Server for High Availability of the server.

Solving the request raised by the user support.

Participate in implementation of the new releases into production.

Facilitates application deployment and joint effort deployment.

Meet the Service Level Agreement established.

Day-to-day administration of live SQL Server.

Designing and implemented security policy for SQL Server.

Used Store Procedure, DTS package, BCP for updating server.

Designed and implemented comprehensive Backup plan and Disaster recovery strategies Implemented and

scheduled replication processes for updating our parallel server.

Automated messaging services on server failure, for task completion and success.

Execute procedure to accomplish short term business goals.

Deploying Administration tools like SQL DB access, Performance Monitor and Backup Utility.

Table partitioning to improve I/O access.

Enforce Database Security by managing user privileges and efficient resource management by assigning

profiler users.

Use Database level triggers code for Database consistency, Integrity and Security.

Implemented periodic database maintenance jobs for running Database Consistency Checks (DBCC),

scheduling the DBCC to run daily and weekly basis.

Created SSIS packages for data migration,

Configured reporting server, developed reports using SSRS, deployed and configured security access and

subscription for various internal management users

Active 24/7 production support.

Database Administrator (July 2010-April 2013)

The Business Real Estate Dubai Marina, UAE

Description: Real Estate Company uses SQL Server 2005 and later on upgraded it to SQL Server 2008 as part

of the Admin Management System to make reports, analysis and tracks of more than Seven Hundred thousands

of Properties. The system automates activities of all Real Estate in RDBMS including the number and kind of

business activities and files, organizational structure, recruitment, transfer of employees, pro motion, demotion,

training, leave management, salary increment, report, document management and overall performance

evaluation of properties.

Responsibilities:

Mufti Ali

724 Hamilton St NW, Washington DC 20011

************@*****.*** +1-240-***-****

Installed the SQL Server 2005 and 2008 at the beginning of the project.

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.

Generating case reports for day to day business activities.

Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers.

Managing the use of disk space, memory and connections. Running DBCC consistency checks and

analyzing stack traces, if generated

Assigning the database users to particular groups /New Property Consultant/

Database and log backups & restoration, backup strategies, scheduling backups.

Implemented SQL server high availability tools like Log shipping and used Failover clustering as well

carefully scheduled maintenance to minimize downtime.

Solved Concurrency problems of blocks, locks, deadlocks, by viewing and tracking them using Activity

Monitor and Management Studio summery page and Profiler.

Assist clients with property sales and development

Hold open house inspections, instructing clients on best practices for selling success and liaising between

renters/owners and prospective buyers for property inspections

Preparation of legal documents including listings and sales contracts

Provide legal, economic and market advice to prospective clients

Liaise with lenders, home inspectors and pest controllers prior to contract negotiations

Ensuring terms and conditions of agreements are met

Maintaining and liaising with clients, building relationships with clients to encourage returning business

Coordinate property closings and overseeing document signing

Analyze market trends to determine competitive market prices

Reference upon Request

Contact this candidate