Occupation:Database Administrator |
Location:Alexandria, VA |
Education Level:Master |
Will Relocate:YES |
Description
Experience Summary: * Over 6 years of experience in IT industry in different business Segments like nonprofit, manufacturing and healthcare. I have a very good foundation of RDBMS concepts and have been involved in development and design of Databases, data analysis and reporting. I have a sound understanding of the entire phases of Software Development Life Cycle (SDLC). I am proficient in SQL Server 2000/2005/2008/2008R2/2012/2014 installations, migration, capacity planning, automated Backup Implementation and performance tuning. * I assist companies to have a secure, optimized, documented and reliable SQL Server infrastructure by properly implementing best practices, automation and keeping up with the latest trends in database technology and using third party tools. I am open to learn new technologies as needed. SQL Technical Skills: SQL Server Administration: * SQL Server 2014,2012, 2008R2, 2008, 2005 and 2000 * Database Mirroring Log Shipping, Replication, Fail-over Clustering, Always ON AG * SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Profiler/Server Side Trace, Database Tuning Advisor (DTA), Query Analyzer, DBCC, DMV, TDE, Solar wind, TSM, SCOM, Cherwell (Service Management ), AVAMAR, DD Boost * Pursuing MS SQL DBA certification MS SQL Server (01/2015- Present) Responsible for installation configuration and complete administration of different versions of SQL Server (2000 to 2014 AG groups and Traditional Clusters) * Implementation of robust backup and recovery strategies using Native SQL client TSM DD Boost and AVAMAR * Apply best practices to the SQL Server infrastructure. * Perform database refresh from higher to lower environments GIZ ara shoes AG, German shoe manufacturer * Installed, configured and managed SQL server 2005, 2008 and 2008R2 in Development, Test and Production Environment. * Applying SQL Server Cumulative Updates & Service Packs. * Migrating 2005 SQL server Database to 2008R2 SQL server Database and prepare documentation * Applying best practices and performing Database health check procedures including DBCC and rebuilding indexes. * Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency. * Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required. * Administering SQL Server security by enforcing security policy and promote best practices. * Creating different maintenance plans to monitor the database for example for Error log, Space usage, automated backup and checking database health Responsible for installation configuration and maintenance of MS SQL Server on various environments * Administering SQL Server by creating user logins with appropriate roles dropping and locking the logins monitoring user accounts creation of groups granting privileges to users and groups. Responsible for routine Backups and Restoration. Responsible for Performance tuning of SQL servers by managing disk space memory and CPU * Administration and Production support for various applications in all environments. Implemented log shipping. Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources creating packages for different data loading operations for application.
Accomplishments
Highlights:
Keywords
