Sql Server Sales
Resume:
Absalom Haile
**** ********* ***, ********** ** *2312
**********@*****.*** Cell:
Professional Summary
Certified SQL Server Database Administrator with more than five years of experience on SQL server
database administration, development and design.
Experienced in logical and physical database design, data modeling, implementation and
administration.
Experienced on managing and troubleshooting gigabytes and terabytes SQL server databases
(VLDBs) in Dev, QA, Staging and Production environments.
Experienced on supporting very large OLTP database of size 9TB and troubleshooting performance.
Experienced on Installation, configuration, migration on SQL server 2000/05/08/R2/12.
Solid Experience in moving database using backup and restore, attach/detach method and T SQL
scripts based on the business requirements.
Experienced on data transformation services such as SSIS, DTS, BCP and Bulk Insert from
heterogeneous databases like Oracle, MS Access, and DB2.
Hands on experience and outstanding knowledge on high availability and disaster recovery SQL server
solutions such as Mirroring, Log shipping, Replication and clustering.
Experienced on Backup and recovery using SQL server native tool and third party tools like Idera SQL
Safe and Redgate backups.
Experienced on developing T SQL scripts for administration tasks; create store Procedures, tables,
views, sub queries and triggers.
Experienced on monitoring and tuning servers for better performance using SQL profiler,
performance/system monitor and database tuning advisor (DTA). Experienced on performance
tuning including updating statistics, indexing, tuning, capacity planning and index analysis.
Experienced on creating and assigning database security.
Monitored SQL Servers and apply service packs and hot fixes (cumulative updates) in different
environments.
Experienced on scheduling and automating maintenance tasks such as shrinking database, index
rebuilding, index reorganizing, cleaning up history, updating statistics and taking backups.
Experienced on maintaining SQL jobs, SQL server logs and database functionality.
Experienced on installing and managing SSRS and creating various reports IAW business
requirements.
Absalom Haile
5931 Quantrell Ave, Alexandria VA 22312
**********@*****.*** Cell:
Solid experience on building, managing and deploying scalable integration solutions using MSSQL
integration service (SSIS).
Strong verbal and written communication skills and ability to interact with all organizational level, hard
worker and excellent time Management skills.
Technical Skills
RDBMS: SQL Server 2000/05/08/08R2/12, MS Access 2000/2003/2007.
Server Operating system: Window server 2003/2008/ R2/2012.
Database modeling: Toad Data modeler, ERWIN, VISIO 2003/2010.
Database Programming: T SQL.
Third party tools Redgate /SQL compare, SQL backup and restore bundle/, Idera tools (SQL safe
backup, SQL compliance manager, SQL diagnostic manager), HP Hardware diagnostic tools and ACU.
Reporting: SAP Crystal report, SQL Reporting Service /SSRS/.
Virtual machine: MS virtual PC and VMware workstation.
ETL tools: SSIS, DTS (Data transformation services).
Office: MS WORD2003/2007/2010, Excel 2003/2007/2010, Power Point 2003/2007/2010.
Networking: SAN, LAN, WAN.
Applications: IIS, Visual Studio, Adobe Photoshop suite, Dreamweaver, AutoCAD.
Employment History:
SQL Server Database Administrator 05/2011 – present Micron
Micron is a leading global advanced semiconductor solutions provider and an important contributor to the
DRAM, Flash, and Solid State solutions that are used in today’s most advanced computing, networking, and
mobile products. It has more than 43 branches of manufacturing, sales and design offices throughout the
world.
All the transactions and other web applications which give different services for clients and for internal
employees are supported by the SQL server databases at the back end.
Responsibilities:
SQL Server Database Administrator
Absalom Haile
5931 Quantrell Ave, Alexandria VA 22312
**********@*****.*** Cell:
Worked across 52 servers and more than 200 databases with OLTP Database Size 9 TB.
Installed SQL Server 2012/2008R2/2008/2005 on windows 2008/2003 environment.
Plan, install, and configure SQL Server; apply service packs and hot fixes (cumulative updates) for
Quality, Staging and Prod environments.
Experienced on database upgrades from one SQL version to another SQL version.
Transfer/migrate SQL jobs, packages and databases to QA, Staging and Prod environments.
Set up and manage log shipping, mirroring and replication in production environment.
Design and implement database backup and recovery plans.
Perform Backup and recovery using SQL server native tool and third party tools such as Idera SQL Safe
and Redgate backups.
Performing daily checkup /checking SQL jobs, replication latency, HP array configuration, diagnostics
for hard drives, SQL safe console for backups, SQL Server logs and window event viewer, Idera SQL
safe and Redgate etc/ to ensure the health of the servers.
Analyze and deploy different scripts in prod environment based on change request from different
department users.
Maintained database security. Assign appropriate server role and database role for different users.
Monitor and tune Servers for better performance using SQL profiler, Performance/System Monitor and
Database Tuning Advisor. Solid experience in performance tuning including updating statistics, re
indexing, physical table partitioning, capacity planning and index analysis.
Create SQL server database stored procedures, views and triggers to process business rules and data
logic.
Mange cubes performance in SSAS using different system views, process partitions and give different
roles for users to access the cubes.
Schedule and Automat Indexing, Backup, updating statistics and different SSIS packages using SQL
Server job agent.
Use DBCC statements (CHECKDB, SHRINKFILE, CHECKCONSTRAINTS etc) to check the physical
and logical consistency of the databases.
Responsible for maintaining SQL jobs, SQL server logs and database mail functionality.
Strong experience working as a team and individually and experienced in 24x7 on call production
support.
SQL Server Database Administrator 10/2008 – 11/2010
Absalom Haile
5931 Quantrell Ave, Alexandria VA 22312
**********@*****.*** Cell:
Coffee plantation Development Enterprise (CPDE)
CPDE is a huge plantation, retailer and exporter of coffee and other side products. It has three big regional
plantation sites and more than 16 sales offices. It has more than 30 databases which consist of information on
production, warehouse management, customer and sales records and so in relational databases.
Managed and maintained all the regional sites’ and sales offices’ databases, with an emphasis of design integrity
and operational excellence through teamwork, continuous improvement, customer satisfaction and efficient work
processes.
Responsibilities:
Responsible for installation and configuration of SQL server 2005 on windows 2003 environment.
Designed, installed and managed log shipping, replication and mirroring.
Designed, developed, and implemented full /differential /transactional data backups and restoration
procedures.
Created Constraints, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Temp tables and
Dynamic SQL queries.
Responsible for Database design, normalization, creation database and database objects etc.
Scheduled and Automated Indexing, Backup, updating statistics using SQL Server job agent.
Created DTS packages to maintain central repository. Extensively used different SQL2005 DTS tasks.
Installed, deployed and managed SSRS; created various reports IAW business requirements.
Used SSIS to extract, transform and load data from source to destination.
Responsible for maintaining SQL jobs, SQL server logs and database mail functionality.
Developed SQL scripts for administration tasks.
Audited database usage and transactions, removed orphan users.
Used SQL Diagnostic Manager and SQL Compliance to analyze locks, Blocking and Memory
Utilization.
Monitored and enhanced database and server performance
Created user logins and assigned appropriate roles to system users.
Education & Training
• B.SC. In Industrial Engineering, Mekelle University.
Absalom Haile
5931 Quantrell Ave, Alexandria VA 22312
**********@*****.*** Cell:
• Training on database Modeling, T SQL programming, SQL Server database Administration, SQL
Server reporting and SQL Server integration Service: New Horizons.
Status Green Card Holder
Professional Certification
MCTP Microsoft® Certified Technology Specialist SQL Server 2008® – Implementation and Maintenance.
Contact this candidate