SUMMARY

• A Microsoft Certified IT Professional, with 7+years of MSSQL Server DBA/Development experience seeking an opportunity to work as a SQL Server DBA/Developer.
• Perform Relational Database administration and maintenance of SQL Server, MySQL and PostgreSQL.
• Perform troubleshooting tasks related to system and data communications software and hardware.
• Install and configure standalone and cluster windows servers on VMware vSphere and physical servers
• Experience in Active Directory management, Creating and adding Admin Accounts, users, groups, etc.
• Expertise in optimizing database uptime and availability, and maintaining database physical integrity.
• Experience in installing, configuring and maintaining HA/DR solutions; Log Shipping, Mirroring, Replication, Clustering, and always on features.
• Perform user maintenance such as adding users, roles, and maintaining security to database objects.
• Expertise in database migration from SQL Server, &, 2014.
• Perform production software deployment, production system configuration and administration.
• Experience with T - SQL for creating, altering, and maintaining databases and database objects.
• Monitoring DB issues like Memory, CPU, I/O, disk utilization, blocking, deadlocks, fragmentation, etc.
• Experience with recovery models and providing backup and restore functions.
• Program various server routines like user-defined functions, user-defined stored procedures and triggers.
• Perform daily monitoring to include backups, error and system logs, disk utilization, etc.
• Experience in creating, setting up and scheduling jobs for database administration.
• Expertise creating and scheduling SSIS packages to move data between DBMS.
• Provide best practices implementation for database security, availability, recoverability & performance.
• Consult on DBMS product features, potential weaknesses, or upcoming release features for planning.
• Install/configure/secure/deploy reports/administer SQL Server Reporting Services (SSRS).
• Experience with ETL using SSIS, BCP and Import/Export Wizard.
• Manage servers on Windows Server 2012/08/03, VMware and Hyper-V environments.
• Participate in special projects; and perform other duties as assigned.
• Keep log of changes to servers, performance issues identified and corrected system administration and operational procedures, system software installation and maintenance.

TECHNICAL SKILLS

SQL Server Tools: SSMS, Configuration Manager, Query Analyzer, SQL Profiler, DB Tuning Advisor, Report Builder, BCP, Mirroring, Replication, Log shipping, Clustering, SSIS, SSRS, SSAS.

Database: MS SQL Server 2014/12/08/05/00 , MySQL, PostgreSQL, SPSS, MS Access, SharePoint, Excel

Operating System: Windows Server 2012/08/03/00 , Linux (Centos and Red Hat), XP, MS-DOS, VMware

Languages: SQL, T-SQL, PL/SQL, HTML, Win Batch, CMD.

Third-Party Tools: Spotlight, Idera compliance manager, Red Gates, Toad for SQL and MYSQL

Networking: Directory, TCP/IP, LAN, WAN

Documentation and Ticketing: JIRA, Confluence, Service Now.

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Database Administrator

Responsibilities:

• Install, configure and maintain MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 database servers in Production, Test and Development environments, and apply patches and hot fixes.
• Installed and configured windows Multi-Site Failover Clustering in Windows Server 2012 R2
• Installed and configured SQL Multi-Site Failover Clustering for SQL Server 2014.
• Install and Maintain Replication, Fail-Over Clustering, and Always-On environments.
• Also install Configure, and Manage MySQL and PostgreSQL Servers and apply patches and hot fixes.
• Perform various deployments for standard & non-standard changes based on operations procedures.
• Test and deploy new database structures, such as tables, indexes and stored procedures.
• Schedule windows jobs to run daily tasks using windows task scheduler.
• Implement SQL server security best practices and transparent data encryption (TDE).
• Adding and decommissioning users and computers from AD users and Roles.
• Create and manage users and roles and monitor user accounts on SQL, MYSQL and PostgreSQL.
• Configure and Maintain Database Mirroring and Log Shipping, replication and clustering.
• Create and implement backup, recovery plan and point-in-Time Recovery based on requirements
• Configure and manage database maintenance plan including backups, DBCC’s, update statistics, etc.
• Migrated databases, user access and file shares from SQL Server and .
• Deploy Databases and various applications from test, Staging, Development to Production environments.
• Script queries involving joins, views, triggers and stored procedures for diverse business requirements.
• Create Linked Servers to run queries between servers and data sources using ODBC & OLE DB drivers.
• Create and modify tables, table partitions, Indexes, Constraints, Views, to improve performance.
• Develop and install SSIS packages, windows tasks, and SQL Server Agent Jobs.
• Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS and BCP
• Monitor, troubleshoot and resolve issues, such as CPU, Memory, I/O, disk Space, blocking, deadlock, index fragmentation, growth patterns, Error logs, database integrity, connectivity, etc.
• Optimize performance using Execution plan, PerfMon, Profiler, Database Tuning Advisor, DMVs, etc.
• Use T-SQL to create, alter, drop, delete, insert, update, etc. of databases, tables, views, and so on.
• Assisted SQL Server Database Developers in code review and optimizing SQL queries.
• Configure and setup Mail Server on various alerts for e-mail notification.
• Respond to problem tickets and maintain documentation for various tasks and operation procedures

Environment: SQL Server5, MySQL, Linux Centos & Red Hat, Windows Server, Hyper-V, Active Directory

Confidential, Washington D.C.

SQL Server Database Administrator

Responsibilities:

• Install, Configure, and Manage SQL Server 2008 R2 and SQL Server 2012 on development, test, staging and production environment and apply Service Pack and HOT Fixes.
• Install, configure and manage MySQL and PostgreSQL databases, and apply patches and fixes.
• Create and manage users and roles and monitor user accounts,
• Configure and Maintain Database Mirroring and Log Shipping.
• Installed Configured and Maintained Fail-Over Clustering, Replication, and Always-On environments
• Create and implement backup, recovery plan and point-in-Time Recovery based on requirements
• Configured maintenance plan including backups, DBCC’s, update statistics, maintenance cleanup, etc.
• Developed a roll out plan for a big database migration project between servers to a new system.
• Migrated user access, databases, and file shares from SQL Server to a new system.
• Deploy Databases from test, Staging, Development to Production environments.
• Script queries involving joins, views, triggers and stored procedures for diverse business requirements.
• Created Linked Servers to run queries between servers & data sources using ODBC & OLE DB drivers.
• Created and modified tables, Indexes, Constraints, Views, to improve scalability and performance.
• Monitored SQL Server to resolve dead locks, memory, index, and other performance issues.
• Administered and supported SSIS and SSRS servers and installed SSIS packages and procedures.
• Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS and BCP
• Created simple and parameterized SQL Reports, and develop and deploy reports using SSRS
• Configured and setup Mail Server on various alerts for e-mail notification.
• Administered and used JIRA for ticketing and CONFLUENCE for documentation.
• Responded to problem tickets and maintain documentation for SQL system software configuration.

Confidential, Sterling, VA

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 and 2005 in development, test, and production.
• Applied SP (Service Pack) and HOT Fixes on SQL Server 2005 and 2008
• Installed, Configured, and administered SSIS, SSAS and SSRS Servers.
• Created and managed users, creation of groups and granting privileges to users and roles.
• Script queries involving joins, views, triggers and stored procedures for diverse business requirements.
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Partitioned tables which have frequent inserts, deletes and updates to improve performance.
• Performed statistics management, managed Error Logs, space usage and growth pattern.
• Fine tuning long running queries and slow running server using various tools.
• Performed database Migration from SQL Server 2005 to SQL Server 2008
• Performed Database Backup and restore, including Point-in-Time Recovery.
• Created and modified tables, Indexes (Cluster/Non-Cluster), Constraints and Views.
• Implemented High availability strategies like log shipping, Replication, and Mirroring.
• Export/Import data from/to various data including flat files, excel, and CSV files to/from SQL Server.
• Designed and deployed ETL solutions in SSIS and created SQL Server Agent jobs.
• Created documentation for installation, procedures, configuration changes, best practices, etc

Confidential, Addis Ababa, Ethiopia

Data Analysis Expert

Responsibilities:

• Provided database administration and support of MS SQL server 2000.
• Installed, Configured, and Managed SQL Server 2000 in development, test, and production.
• Defined & implemented processes required for proper data conversion from the existing system to new.
• Installed and configured new SQL Server 2000 Database Server instances.
• Managed User Logins, roles, monitoring user accounts, granting privileges to users and groups.
• Performed Full Backups, restore them whenever necessary and created back up strategies.
• Monitor Server Activity, and solving problem as needed
• Created documentation for installation, procedures, configuration changes, best practices, etc.