Occupation:Database Administrator |
Location:Teaneck, NJ |
Education Level:Bachelor |
Will Relocate:YES |
Description
Career Summary * 8+ years of experience in Database Administration for different applications as a SQL Server DBA Consultant. * Experience in Installation of SQL Server configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates. * Good Experience in high availability and recoverability of databases in 24/7 environment by using clustering, replication, mirroring, log shipping, backup and restore to meet RTO/RPO objectives. * Experience in deploying, configuring and administering Always On: Availability Groups. * Upgrading/Migrating SQL Server to higher versions 2008, 2012, 2014. * Strong command of performance tuning and proven experience in troubleshooting performance problems (Indexing, Optimizer, server configuration, Profiler, DMV etc.) including TSQL programming and debugging skills. Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts. * Expert in implementing High Availability options Failover Clustering, Log shipping, Mirroring and Replication (Transactional, Snapshot & Merge) and migration. * Experience in SSIS packages and SSRS reports deployment. * Experience in creating Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases. * Expertise in dimensional modeling in Star and Snowflake models. * Administered and supported 150+ number of instances. * Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer. * Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions. * Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans. * Experience in Managing and Configuring Backup and Recovery strategies for Databases. * Played a key role in business requirements analysis, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
Accomplishments
Highlights:
Keywords
