Resume

Sign in

Sql Server Data

Location:
San Francisco, California, United States
Salary:
120000
Posted:
October 25, 2018

Contact this candidate

Resume:

TEWODROS WOLDEMARIAM

ac7hrf@r.postjobfree.com

202-***-****

CAREER OBJECTIVE

Over 5+ years of professional experience as a SQL Server Database Administrator with proficiency in managing very large and highly transactional database systems. Highly motivated and take initiative to manage and work on different projects individually and as a team. Have strong business and technical vision with effective people skills, and has high aptitude for learning new technologies. Characterized throughout employment as a self-starter; an individual committed to delivering solutions and possessing the ability to apply complex technologies that translate business needs into a practical reality.

DBA Skills

● Capacity management ● Data Modeling ● Installation and Configuration ● Backup/Restore

● Updates and Patches .TDE Encryption ● Security ● Performance Tuning ● SSRS/SSIS

●Automation ● Virtualization- VM ware/Hyper-V ● Always ON ● Azure ● SQL Failover Cluster

Log Shipping ● IIS ● Mirroring ● SharePoint ● Documentation ● Project management

PROFESSIONAL SUMMARY

● Expertise in Database Administration on Production Servers with Server Configuration Performance Tuning and maintenance with outstanding troubleshooting capabilities.

● Experience on High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and Always On Availability Groups, Replication, Log Shipping and Mirroring.

● Experienced in Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2, from SQL Server 2012 and SQL Server 2014.

● Experienced in installation, configuration, maintenance and optimization of SQL Server HADR solutions.

● Experienced in Backup and Recovery, Query Optimization and Security.

● Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions.

● Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.

● Created various SSIS, SSRS and SSAS Packages to serve company needs.

● Expert in using DTA/Extended Events/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, Deadlocks and slow running queries.

● Able to benchmark and load test new instance builds for performance with DB load simulators.

● Responsible for securing SQL Server, user management, assigning permissions and roles.

● Strong System Administration background in Windows and Linux environments.

● Experienced with Development/Test/Production QA which included documentation of processes creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.

● Experienced in creating technical documentations and process archiving and change management.

● Experienced in working independently as well as in team-oriented environments.

● Experienced in supporting and maintaining large databases and troubleshooting their problems.

● Knowledge on cloud computing technologies such as AWS EC2 and Azure.

● Team player, willing to share and develop my knowledge and experience

PROFESSIONAL EXPERIENCE SQL DBA

APEX SYSTEMS

SANFRANCISCO CA

Database Administrators

March 2017 - Present

Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.

Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.

Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.

Revise company definition of data as defined in data dictionary.

Review procedures in database management system manuals for making changes to database.

Work as part of a project team to coordinate database development and determine project scope and limitations.

Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.

Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.

Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.

Modify existing databases and database management systems or direct programmers and analysts to make changes.

Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Test programs or databases, correct errors, and make necessary modifications.

9\2011 to 9\2013- Alameda Health Consortium\Community Health Center Network-San Leandro, CA

10/2014to 10\2016 GEICO – Chevy Chase, MD

● Involved in developing logical design and physical design.

● Created Documentation for steps need to be taken while upgrading.

● Installed and configured MS SQL Server 2016, 2014.

● Migrated SQL server 2008R2 to SQL server 2016.

● Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.

● Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.

● Worked with SQL server Profiler to generate traces.

● Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.

● Identified long running stored procedures and SQLs using profiler and fine-tuned for maximum performance.

● Expertise in setting up and troubleshooting Database mirroring.

● Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi- Production Servers and handling maintenance Jobs.

● Use SQL Server RML Utilities to do performance baseline analysis report between the SQL Server 2005 and SQL Server 2008R2.

● Extensively worked on IMS performance issues like update statistics, reorganizing and rebuilding the indexes at regular intervals for better performance.

● Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.

● 24/7 on call support, created various jobs to check health of the server and to troubleshoot.

● Export or Import data from other data sources like flat files using Import/Export through, SSIS.

● Huge data of Insurance policies and customer information in XML, Flat file data transformation using SSIS Packages.

● Developed SSIS packages, stored procedures, functions, triggers.

● Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.

● Hands of experience in writing batch files.

● Worked closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.

● Configured and monitored Replication, Mirroring, Always ON clusters.

● Data Modeling Experience including Physical and Logical data modeling using Erwin tool.

● Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe. Environment: Windows Server 2008 R2, Windows 2012 R2 Server Database: MS SQL Server 2008R2/2014/2016 Monitoring and solving incident tickets, change requests and service calls in 24/7 environment, adhering to SLAs

● Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.

● Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.

● Created and migrated partially contained databases within Always On Availability Groups.

● Created automation of day to day operations, critical SQL server alerts and repetitive tasks.

● Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler performance tool and other third party tools.

● Tested newly built servers for performance impact with DB load simulators.

● Setup and maintained Log Shipping between various environments.

● Worked on Dev/Test/Prod environments which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.

● Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.

● Operated and oversaw database and log backups and

● Optimized the Indexes, adding/deleting them when necessary for better performance.

● Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.

● Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.

● Worked with installation, configuration and creation of SSRS.

● Decided whether clustering, log shipping, mirroring, replication & are the right fit to solve a business problem.

● On-call troubleshooting for SQL Server service outages.

● Responsible for securing SQL Server, user management, and taking care of permissions and roles. Environment: Microsoft SQL Server 2014/2012/2008R2 Enterprise and Standard Editions, Windows 2012/2008R2, Clustering, Always On, Mirroring, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio 2012, TOAD for MYSQL, Microsoft Office 2013. SQL DBA Intern & SQL DBA 02/2010 to 08/2012 Humphrey Management – Columbia md

● Installed and Configured SQL Server 2005/2008 R2

● Responsible for MS SQL Server 2005 /2008/2008R2 database administration.

● Diagnosed server problems and employed preventive measures to maintain high availability of MS SQL Server.

● Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.

● Worked on change requests, permission requests and refreshes requests.

● Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.

● Configured and maintained Transactional, Snapshot and Merge replication.

● Worked with SQL Disaster Recovery processes like Log shipping methodologies, clustering and mirroring.

● Worked with capacity planning, database sizing and monitoring.

● Performed critical Patch management.

● Established and recommend policies on system use and services.

● Provided emergency after hours support for mission critical applications and any upgrades/maintenance as required.

● Provided records and data on specific performance/availability concerns as basis for problem identification/ resolution and management reporting.

● Maintained user security and overall application and database data integrity, knowledge of SSL deployment and support in a SQL Server environment.

● Used helpdesk software to manage support cases assigned.

● Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.

● Worked with application team to test the successful upgrades, migrations and installations. ● Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Environment: SQL Server 2005, SQL server 2008, T-SQL, SQL, Windows 2003/2008 Server, Import & Export Data.

EDUCATION and CERTIFICATION

Computer Science BS 2003 Addis Ababa University- Addis Ababa Ethiopia

Microsoft Certified Solutions Associate (MCSA) 2008&2012

TECHNICAL SKILLS Languages: T-SQL, HTML, CCS, Java, Java Script and XML Reporting & Audit Tools: SSRS, Report Builder and SSDT, IDERA SQL Compliance Manager and SQL Secure RDBMS and Tools: SQL Server 2005/2008/2008R2 /2012 /2014, MS Access 2007/2010/2013 MySQL, SQL Loader and Export/Import, PowerShell. Virtualization: VMware and Hyper-V

Third-party Tools: Red Gate, Spotlight, and IDERA SQLSUITE, PHPMYADMIN, OLAS Maintenance Scripts, Putty, Wireshark. Backup Software: SQL Backup, Lite Speed, Red Gate, IDERA SQL Safe, and Backup Exec. ETL Tools: SSIS, BI (BIDS/SSDT).

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer, Toad for SQL/MySQL Data Modeler: SSAS, SQL Developer Data Modeler, TOAD Data Modeler. Operating System: Windows 7,8, 10, Windows 2003, 2008R2 and 2012R2 Servers



Contact this candidate