Sql Server Real Estate

Shambel Alemu

PH: 202-***-**** Email: ********@*****.***

Professional Summary:

Over 6 years of MS SQL Database Administration experience in Real Estate, Retail, and Insurance domains with expertise in installation, configuration and administration of MS SQL Server 2016/2014/2012/2008/2005/2000.

Intensive experience in project development life cycle including business process analysis, requirements gathering and analysis, high level and detailed design, development, testing, QA and post implementation support.

Maintaining database systems including but not limited to ensuring successful backups and restore, resolving system issues, closing cases, monitoring success and failure of automated jobs, monitor high availability and disaster recovery

Monitoring and Troubleshooting High Availability Technologies: Windows Failover Clusters, AlwaysOn Availability Groups, Log Shipping, Database Mirroring and Replication.

Physical and logical database design and modeling; promote the security, reliability and performance of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

Thorough understanding of configuring and tuning of Utility Control Point (UCP) to gather configuration and performance related information from SQL server.

Expertise in Tuning slow running queries using native SQL Server tools and third party application to evaluate joins, indexes, updating Statistics and code modifications.

Online indexing, Contained Databases, security principals and AAG (AlwaysOn Availability Group).

Expertise in both OLTP & OLAP high volume transaction environment that includes 24x7 Production, Quality Assurance, and development databases in SQL Server

Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML)

Expert in implementing Management Data Warehouse (MDW) in various versions of SQL Server

Implementing and Administering Cloud Computing and Virtualization Technologies: Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) in Microsoft Azure

Education Achievement:

Bachelor in Information Sciences

Microsoft Certified Professional (MCP) Administering MS SQL Server 2012

Tools and Technologies:

MS SQL Server 2016/2014/2012/2008/2005/2000, SQL Server Integration Services, SQL Server DTS, Database Mirroring, MS Windows Failover Clustering, AlwaysOn Availability Groups, Replication, Log Shipping, Cloud Computing in Microsoft Azure Platform, MS Word, MS Excel, PowerShell, Visual Studio, SSDT

Professional Experience:

Xceligent, Kansas City, MO

Xceligent is the leading provider of verified commercial real estate information across the United States. My major role and responsibilities as a Database Administrator for the company was focused on maintaining, and optimizing the existing databases; monitoring database performance and growth, performance tuning of SQL server.

SQL DBA/Engineer Aug 2013 – June 2017

Responsibilities:

Provide 24 X 7 critical production supports to numerous production, development, stand-alone and clustered servers.

Proactively monitored the production database(s), Tuning Performance and optimize stored procedures specifically in SQL Server 2012 Environment.

Implemented and maintained high availability solutions that included Windows Failover Clustering, Database Mirroring and Log Shipping.

Successfully migrated 100+ SQL 2008 databases to SQL 2012 and 2014.

Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2008 to MSSQL 2012, 2014.

Employed Resource Governor to control and allocate CPU and memory resources depending on the priority of the applications which involves Configuration of Resource Pools, Workload Groups and Classification Functions.

Implemented different backup strategies such as full backup, differential backup and Transactional log backups depending on the need of the company.

Engaged in using Piecemeal Restore on SQL server to recover missing file groups in stages while the database is still online.

Implemented Peer-to-Peer replication typology to provide a scale-out and high availability solution by maintaining copies of data across multiple servers.

Developed Conceptual and logical models by creating entities, attributes and implemented relationship and integrity rules.

Transformed the logical data models into physical models that organize the information into appropriate data types implementing constraints and tables for optimum performance and storage.

Review of Logical and Physical database design to promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

Extensively worked in troubleshooting hardware and software issues, resolving locking and blocking conflicts and resource utilization in SQL server.

Implemented security, generate and review report periodically and enforce security mechanism, recommend policies and procedures for ensuring security of company’s IT infrastructure

Implementing change control mechanism, benchmarking, capacity planning and managing database growth and disk space utilization

Provided customer support, managed and resolved database-related issues submitted by clients.

CVS Caremark, New York, NY May 2011 – Jul 2013

CVS Caremark’s approach as benefit management is aimed at improving savings and providing an unmatched member experience to its members across the USA. These capabilities translate well to medicine, where it is imperative that caregivers have the right information at the right time to provide patients with optimal care.

SQL Server Database Administrator

Core Responsibilities:

Created and maintained logins, mapping users to logins and managed security based on access privilege on production and development environments

Monitored and tuned SQL Server databases for optimum performance and resource utilizations to avoid bottlenecks and troubleshoot when they occurred

Created and maintained various databases on Production and development environments using SQL Server 2012/2008/2005.

Created jobs to import/ export data obtained from various States to update the GIS servers.

Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.

Installed necessary Service Packs for SQL server 2005 and upgraded legacy 2000 databases to SQL server 2005/2008.

Implemented Database Backup strategies based on Company’s RPO and RTO and Restore options

Implemented High Availability Solutions on the various servers using replication, mirroring and log-shipping

Used stored procedure in a backup and restore process to copy data from development node to a production node.

Mainly utilized SQL Server Profiler, X-events, Performance monitor, Activity monitor, SQL Server Agent, DMVs and Database Engine Tuning Advisor (DTA) for monitoring, performance tuning and automation of jobs.

Day-to-Day administration of SQL Servers in Standalone and Cluster Environments such as troubleshooting connectivity issues, fixing bugs, scheduling database maintenance plans, performing health checks, and ensuring the security of databases and IT infrastructures

Responsible for Load and Performance testing of the database and application servers; configuring and deploying SSIS Packages from Test to Production Environments.

Conducted various meetings and conferences with application teams, and executives to meet corporate milestones for database consolidation and data migration.

Energizer, St. Louis, MO Mar 2010 – April 2011

Energizer Holdings is an American manufacturer of batteries and personal care products. The project involved interacting with various customers and analyzing their SQL server environments and making suggestions and implementing recommendations for better performance. The project also tasked with setting up new SQL environments for various customers.

SQL Database Administrator

Responsibilities:

Planning, Defining and Designing database based on business requirements and provided documentation.

Managed multiple SQL servers, optimized databases for better performance and administered Server and database security on production and development environments.

Supported IT Operations by performing database related analysis tasks, report writing and handling multiple database projects.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.

Manage the functionality of many interfaces and map data to user interface design or enhancements and ensure correct functioning, retrieval and update of data.

Migrated databases from SQL server 2005 t0 SQL Server 2008 using SQL Loader, Import/Export wizards, bulk import and batch processing

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Installed, authored, and managed reports using SQL Server 2008 Reporting Services.

Analyzed long running slow queries and tune to optimize application and system performance.

Monitored the servers using third party software and worked on SQL Server native tools such as Enterprise Manager and SQL Query Analyzer.

Pulte Homes, Bloomfield Hills, MI Dec 2009 – Feb 2010

Pulte Homes is a homebuilding company that provides customer service in real estate throughout the initial to final phase of any real estate project. The Project involved in developing Enterprise level database objects that collects, organizes and stores data from different operational data sources to provide a single source of integrated and historical data.

MS SQL DBA

Responsibilities:

Involved in Planning, Defining and Designing database based on business requirements and provided documentation.

Performed business analysis, technical analysis, systems design, application software programming and Entity Relationship (ER) diagrams.

Monitored SQL server performance using native tools to find performance bottlenecks and deadlocks issues.

Extensively worked on table Partitioning, DBCC commands to enforce database consistency and integrity and Dynamic Management Objects for monitoring internal server states at specific time

Handled multiple SQL Server Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Identified, tested and resolved database and T-SQL performance issues to ensure data optimization for queries that take longer execution time.

Rebuilding and reorganizing the indexes at regular intervals to avoid index fragmentation and improve better performance.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.

Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.

Maintained security policies, Managed Logins and User, adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.

Contact this candidate