Sql Server Data

GELILA M HABTEMARIAM

***** ****** **** **, ***** ridge, VA 20105 Cell-Phone: 571-***-**** *******@*****.***

OBJECTIVE

Obtain a full time position that utilizes my strong analytical and quantitative background as DBA

EDUCATION

Bachelor of Science Computer Science Dec 2008

Radford University Radford, VA

Major - Computer Science – Database (B.S.)

CERTIFICATION

Administering Microsoft SQL Server 2012 Databases

SUMMARY

6 years of programming experience as an DBA

Involved in all phases of the SDLC (Software Development Life Cycle)analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Experience with data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling and design techniques

Expertise in SQL query coding

Develop, modify, and amend data in systems using SQL commands, hand-editing, and automating bulk import.

Be responsible for all aspects of data structure, logic, internal applications that interface with the database, data availability, and data quality.

Install, configure, and maintain database management systems software.

Good knowledge on logical and physical data modeling using ER Studio

Analyze and sustain capacity and performance requirements

Developed complex database objects such as stored procedures, functions, packages, views and triggers using SQL and PL/SQL

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP

Experience in Oracle supplied packages, dynamic SQL, records and PL/SQL tables

WORK EXPERIENCE

DHS/USCIS/CSC Washington, DC

Development/Production Relational DBA Aug2014 –Present

Monitors database activity and file usage, and ensures necessary resources are present. Determines data to collect and analyzes information as appropriate. Investigates and resolves technical database issues of significance.

Oversees the analysis and determination of database performance characteristics, informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases. Recommends and implements tuning opportunities to improve system response and run times.

Defines logical attributes and data inter-relationships and designs complex data structures to accommodate database production implementation, storage, maintenance and accessibility to enhance performance.

Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. Limits database accessibility based upon information security level and ensures data spillage from more secure to less secure databases does not occur.

Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; installs necessary security patches to ensure ongoing database security.

Plans and installs upgrades of database management systems (DBMS) software as necessary to enhance database performance. Researches various hardware and software products; recommends solution and implements approved products.

Functions as a technical team or provides work for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.

Assists project managers in the development of project plans including detailed project estimates and tasks required for database activities. Utilizes standard corporate tools to record change and problem activities for tracking purposes.

Integrates databases and commercial of the shelf software; resolves conflicts between databases and of the shelf software, operating systems, and open source applications.

Designs and tests database installation, implementation, and recovery scenarios. Determines test to use and collects appropriate data according to established guidelines. Participates in analysis, development and implementation of unique database recovery plans in response to client-impacting outages.

Ardent management consulting Reston, VA

SQL Server DBA/SQL DEVELOPER Apr2014 – May2014

Installing and maintaining SQL Server database systems using SQL SERVER 2012

Coordinating with the Systems Administration team, install and maintain Boardwalk approved application software

Working with development and systems teams to perform application and database tuning using schema and SQL management studio

Experience with SQL Server 2005 to SQL Server 2012

Setup a maintenance plan for appropriate database and application monitoring

Metron Aviation Sterling, VA

Senior Associate DBA/SQL DEVELOPER Nov2008 – Aug2013

Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions

Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required

Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements

Used SQL*Loader, Import/Export, UTL_FILE, DBMS_PIPE and other Oracle built-in packages

Created partitioned tables and partitioned indexes to improve the performance of the applications

Wrote PL/SQL Database triggers to implement the business rules in the application

Created external tables to handle huge volumes of data, which is not used frequently

Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables

Hands on experience in creating different kinds of partitions for managing large tables

Develop database utilities and automated reporting

Create shell scripts for task automation

Create, test and execute data management languages

Analyze and sustain capacity and performance requirements

Analyze, consolidate and tune database for optimal efficiency

Monitor systems and platforms for availability.

Oversee backup, clustering, mirroring, replication and failover

Restore and recover corrupted databases

Install and test upgrades and patches

Responsible for ensuring availability and performance of the databases that support the system

Hand on experience working with clients

Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning

Proactively monitor multiple database systems to ensureand secure services with minimum downtime (both SQL Server and Oracle interface).

G&D America Sterling, VA

Accounts Payable Augest2006 – Nov2008

Maintains open packing slip file and purchase order file

Verifies invoices for quantity, unit pricing, extension and discount. Initiates calls to vendors or other departments to clarify any questionable data regarding invoice payments

Routes miscellaneous invoices to proper people for approval for payment

Assigns general ledger account numbers to voucher for proper distribution to financial statements

Enter and post vouchers in accounts payable system

Use integrated accounting system to process invoices against purchase orders

Completes check printing and prepares check packets for signature

Completes check mailing and filing voucher packets

Maintains vendor files

Answers any questions from departments or vendors in regards to invoice payments.

ONSITE E-DISCOVERY Alexandria, VA

Database Specialist May 2005 – May 2006

Extracts text from various storage media

Creates databases from text extraction

Searches databases for relevant information

Restricts dates on databases for relevant documents

Loads documents in SQL database

Creates images from electronic documents

Deletes duplicate records using proprietary software

Queries SQL databases for errors

Endorses documents with client specified information

LEADERSHIP, PROFESSIONAL AND OTHER ACTIVITIES

President, Women Computing Club

Member, Association for Computing Machinery (ACM)

Recipient, Trio Student Support Services

SKILLS AND INTERESTS

Programming Languages: Java

Web Programming Languages: XML, HTML, JavaScript, PHP

Databases: SQL, PL/SQL, Oracle 10g, Oracle9i

Operating Systems: MS Windows (2000, NT, XP), UNIX

Contact this candidate