Occupation:Database Administrator |
Location:Silver Spring, MD |
Education Level:Associate |
Will Relocate:YES |
Description
Summary of Experience: * Over 5 years of experience as a SQL server Database Administration I have managed databases using SQL Server 2008, 2008R2, 2012, 2014. * Experience Installing, Configuring, and Maintaining SQL Server 2014, 2012, and 2008 R2. * Experience Upgraded/Migrated SQL Server Instances/Databases from older version to new version of SQL Server such as 2008 R2 to 2012 * Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012. * Applied Service Pack (SP) / Hot Fixes on SQL Server Instances to address security and upgrade related issues. * Configured all database servers and backed up in a way that meets the business's Recovery Point Objectives (RPO), Recovery Time Objectives (RTO). * Troubleshooting, Upgrade, Migrate, Performance Tuning, Data Modeling, Security Management, Configuring and Managing HA and DR Solutions (Log Shipping, Mirroring, Replication, Clustering, and AlwaysOn, ), TDE (Transparent Data Encryption), IPSec and SSL. * Developed various T-SQL stored procedures, triggers, views and creating, adding and changing tables for data load, transformation and extraction (ETL) operation. * Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS. * Using SSRS, Delivered reports to users in variety of formats like Report Server (Web-based), Excel, Pdf, HTML, and CSV format, html, excel and CSV formats * Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases * Experience in troubleshooting SQL issues by using SQL Tools, Execution plans, Trace, Statistics and index tuning wizard. * Created maintenance plans to perform index de-fragmentation and update the index statistics. * Experienced in Data analysis, Data modeling, Database design, Data migration Export / Import and Data loads. * Understanding AWS and Cloud Management for Software development. Professional Summary: Certified SQL Server DBA having more than 5 years of professional experience in various Microsoft products with excellent detail-oriented approach, analytical and troubleshooting skills. My skill includes SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems. Solid working experience in managing large databases, backup/recovery, restore and Point-in-Time Recovery, implementing High Availability (HA) options, Scheduled jobs to automate different database activities including backup, monitoring database health check, disk space, backup verification, Developed Maintenance Plans for database monitoring, Monitor Server Activity, Error Log, space usage, and solving problem as needed developing and managing reports using SQL Reporting Services (SSRS) and Creating SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB using SQL Server Integration Services (SSIS). Implementing Performance Tuning, stored procedures, triggers, functions, constraints, and views. Substantial knowledge, and strong experience in using third party tools like RedGate, Idera, SQL Sentry and Toad Data Modeler in managing SQL Server database and designing databases as well as in using Erwin, understanding AWS and Cloud Management for Software development. Having a very good team player skill and has an aptitude for learning can work with little supervision, self-motivated and can easily work with non-technical people while possessing a sense of urgency. Technical Proficiencies:
Accomplishments
Highlights:
Keywords
