Sql Server Manager
Resume:
AWOK SIMEWORK
Silver Spring MD 20910
awokedba@gmail.com____________________________________________________
SQL SERVER DATABASE ADMINISTRATOR
OBJECTIVE
I am a Microsoft Certified Database Administrator with 6+ years of experience in designing, coding,
testing, performance tuning, maintenance, security, high availability, backup and recovery. I have
managed multiple development, test and production servers and provided requirement analysis,
recommendations and solutions for creating, upgrading, integrating, and managing MS-SQL server
database systems in a distributed environment.
I am currently seeking the Position of MS-SQL Server Database Administrator (DBA)/Developer.
SKILLS
MS-SQL Server 2000/2005, O racle PL/SQL (9i/10g/11g),
Databases:
MS Access 97 & 2000/2003.
SQL Server Surface Area Configuration, Reporting Services
Configuration Tools:
Configuration, SQL Server Configuration Manager,
Microsoft Database Upgrade Advisor.
SQL Business Intelligence Development Studio, SQL Server
Development Environment:
Management Studio, Enterprise Manager, Query Analyzer,
Export / Import (DTS), SSIS, Crystal Reports.
Database Engine Tuning Advisor, Profiler.
Performance Tools:
Windows S erver 2003, Windows X P, Windows 2000
Server Operating System:
Advanced Server, Windows Server 2000 data center server,
Windows 98/95.
CIRTIFICATION
Microsoft Certified Technology Specialist in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) -
Implementation and Maintenance.
MEMBERSHIP
Internet Society
SUMMARY
Over 6 years of experience in MS SQL SERVER 2000 / 2005 Database Administration (DBA),
•
database development, design and Production support.
Hands on Experience in installing, configuring, managing, monitoring and troubleshooting
•
SQL Server 2000/2005.
Solid experience and outstanding knowledge of high availability SQL Server solutions,
•
including Replication and SQL Server clustering.
Extensive experience in Monitoring, tuning and analysis of data base performance and
•
server resources allocation to achieve optimum performance.
Extensive experience with SQL Server and T-SQL in constructing Stored procedures,
•
triggers, tables, user functions, views, indexes, user profiles, relational database models,
data dictionaries, and data integrity.
Experience in developing and monitoring SSIS Packages and DTS.
•
Page 1 of 3
Working Experience in designing, implementing, maintaining, troubleshooting and
•
documenting complex database applications, and data warehouse in financial
environments.
Excellent report creation skills using Microsoft Reporting Services
•
Experience in Crystal Reports, and Crystal Analysis.
•
Excellent communication, presentation and interpersonal skills
•
EXPERIENCE
Reznick Group 10/2007 – P resent
SQL Server DBA
Bethesda, MD
Description: Ranked among the top 20 public accounting firms in the United States, Reznick Group is
a national leader in accounting, tax and business advisory services. Reznick Group maintains 10 offices
nationwide, with its headquarters located in Bethesda, Md.
• Installed and Configured new SQL Server 2005 Database Server instances, SQL Server
Integration Services (SSIS), SQL Server Reporting Services (SSRS) for Development, Testing and
Production Environment
• Designed SSIS packages to import data from Oracle 10g and other external data sources.
• Translated PL/SQL scripts that are used against Oracle 10g database functions, triggers and
stored procedures into T-SQL so that they can be used/applied in SQL Server as well.
• Used ORACLE PL/SQL on TOAD to call and utilize Stored Procedures, Functions and cursors etc
that reside in Oracle 10g remote site.
• Performed backing up, restoration and copying of Production Databases.
• Prepared Disaster Recovery Plans and participated in disaster recovery.
• Regularly Monitored SQL server, Application logs and analyzed the logs troubleshooting SQL
Server Problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks,
activity monitor), and SQL Agent job execution problems.
• Created a maintenance plan that monitors data mapping for import/export from the Oracle
database to SQL Server.
• Rebuilt Indexes and Tables as part of performance tuning
• Synchronized Development, Testing and Production servers.
• Maintained and troubleshot replication issues by monitoring replication on a regular basis.
• Installed SQL Server service packs based on the errors and flaws that are found in a particular
application.
• Resolved various performance issues running DBCC commands, SQL Tracer, SQL Profiler and NT
monitoring tools.
• Administered the MS SQL Server security by creating user logins with appropriate roles,
dropping and locking the logins, monitoring the user accounts, creation of groups,
granting/revoking privileges to users and groups as required.
• Performed Full Backups and Transaction Log Backups and restored them whenever necessary;
creating back up strategies and scheduling them for execution.
• Administered Replication and Log Shipping.
• Planed and Scheduled the Online/Offline Backups
• Used the Database Maintenance Wizard to make the necessary changes while keeping the
performance of the server at acceptable levels.
• Provided 24/7 on-call coverage.
Environment: MS SQL Server 2000, MS SQL Server 2005, Windows 2000/2003, Database studios/
Enterprise Manager and Query Analyzer / Query Editor, TOAD, ORACLE 10g,
Gofileroom.
Page 2 of 3
Metro PCS 09/2005 – 10/2007
SQL Server DBA
Atlanta, GA
Description: Metro PCS is a provider of wireless communications services. It is the sixth largest
wireless telecommunications network in the United States. Currently, Metro PCS serves a total of over
6.1 million subscribers. My responsibilities involved monitoring and tuning the database for
performance and availability, modifying database structures, developing database backup/recovery
procedures, providing support and guidance to operational models, and forecasting database and
platform resource utilization, consistence check, security administration, data quality,
documentation, and technical support.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database
consistency check, and index defragmentation.
• Designed dynamic DTS Packages for Landing-Pad to transfer data between servers, load data
into database, and archived data file from different DBMS such as Oracle 9i.
• Automated and scheduled SFTP to transfer data from other systems.
• Created and developed the stored procedures, triggers to handle complex business rules,
history data and audit analysis.
• Maintained cluster servers to provide high availability.
• Set up database backup and recovery strategies.
• Worked with development teams in the design and modification of physical databases.
• Ensured developers coordinated their efforts in managing and maintaining different application
databases.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and
improve scalability.
• Implemented partitioning to handle tables with over 300 million rows.
• Responsible for disaster recovery planning for SQL Servers.
• Created Materialized Views to reduce query run time for the end user.
• Involved in taking backups and exports.
• Participated in unit testing and prepared unit test documents.
• Involved in supporting/fixing post production defects.
• Attended Design meetings, code reviews and test review meetings.
• Interacted and communicated with team members to solve/resolve issues.
• Provided 24/7 on-call support.
Environment: MS SQL Server 2000/2005, Windows 2000, Windows 2000 data center Server,
Enterprise Manager / Query Editor, ORACLE 9i, TOAD.
Commercial Bank of Ethiopia 09/2002 – 04/2005
Database Developer/Administrator/Project Leader
Addis Ababa, Ethiopia
Description: Commercial Bank of Ethiopia (CBE) is the leading bank in Ethiopia established in 1942
and is the pioneer to introduce modern banking to the nation. CBE operates approximately 205
branches across the country. My technical responsibilities included database installations, upgrades
and patches to SQL Server products and environments; manage multiple development, test and
production environments; address issues, such as security, monitoring, performance tuning, analysis
and design and application release management. I was also responsible to provide requirement
analysis, recommendations and solutions for creating, upgrading, integrating, and managing database
systems in a distributed environment.
• Coordinated physical changes and performance monitoring of four replicated production
servers, two development servers and one reporting server, all Microsoft SQL Server 2000.
• Translated logical data structures to physical database objects, identifying data anomalies and
Page 3 of 3
resolving them, and developed programs and queries.
• Responsible for all database architecture and program design, including survey systems, report
developers, OLAP cubes, and interfaces.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS
packages.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other
developers to achieve maximum efficiency and scalability.
• Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps
such as project management systems with minimum development time.
• Profiled and tuned servers on a monthly basis to ensure faster queries and reports.
• Trained developers on how to write better SQL queries, how to use more powerful features like
table variables, how to avoid cursors, etc.
• Wrote installation and procedural manuals for support staff.
• Trained and managed a team of 5 programmers to produce systems on time and on budget.
Environment: MS SQL Server 2000, Windows 2000, Windows NT 4.0, Enterprise Manager / Query Editor,
MS Access 97.
Bahirdar University 10/2001 – 09/2002
Database Developer/Database Administrator
Bahirdar, Ethiopia
Description: Bahirdar University is one of the largest higher educational institutions in Ethiopia that
runs Bachelor’s Degree programs in different Engineering and Social Science fields. The project here
involved the creation and administration of a new database system for the university’s registrar’s
office that can handle comprehensive academic information about every student.
• Actively participated in the entire system development life cycle (SDLC).
• Provided leadership to a team of 8 members during the entire SDLC and implementation of the
project.
• Defined and achieved client needs through one-on-one sessions and on-going communications.
• Insured all artifacts delivered on time
• Specified, designed, and delivered both Applicant and Administrator Module along with the
team.
• Reviewed the database design, and reviewed stored procedures, views, and functions in SQL
Server 2000
• Facilitated functional and UAT (user acceptance test)
EDUCATION
Addis Ababa University, Addis Ababa, Ethiopia
BSc. in Computer Science
Page 4 of 3
Contact this candidate