Occupation:Database Administrator |
Location:Bothell, WA |
Education Level:Bachelor |
Will Relocate:YES |
Description
SUMMARY OF EXPERIENCE: * Over 8 + years of experiences as MS SQL Database Administrator and programmer. Responsibilities include daily SQL optimization, Performance tuning, production support, maintenance review, Disaster recovery planning and ensuring 24x7 supports. * Excellent experience working on different versions of SQL server like 2000, 2005, 2008, 2008r2, 2012,2014,2016. * Expert in the areas of MS SQL Server installation, Configuration, Server upgrade, Database design and normalization, Performance tuning, Security administration, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters. * Strong T-SQL programming skills with real time experience in customizing applications by creating and managing database objects like tables, triggers, views, stored procedures, functions and indexes. * Working experience in Database encryption through TDE using certificate, symmetric and asymmetric keys. * Knowledge on AWS. * Experience in creating Data Model for Data Warehouse. * Securing Organization's Data by implementing least privilege, choosing appropriate authentication modes, data encryption, defining need specific server/database/application roles and granting permissions at granular level as required. * Setup and configured Always on Availability Groups for DR and Reporting. * Ensuring high availability of databases for smooth running of the business by implementing high availability solutions like Database Mirroring, Log shipping and failover Clusters depending upon the criticality of the applications and as per Organizational requirement. * Maintain Data reliability to proactively avoid Data corruption and unexpected performance issues by implementing Maintenance plans and performing Database Consistency Checks that ensures data integrity and consistency. * Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies, setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible. * Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and DB Engine Tuning Advisor. * Working Experience with Bitbucket and TFS. * Working on virtualization technologies on VMware and Physical windows server. * Monitor database server resources and provide recommendations on hardware/software upgrade to increase server performance. * Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance. * Monitor SQL Server using Error Log, Event viewer and application log, and activity monitor for any blocking or heavy locking or high number of suspended sessions and wait stats of top waits. * Experience working with SCOM Monitoring tool. * Planned the complete Back-up of various Databases for Disaster recovery scenarios. * Strong T-SQL developer skills including stored procedures, indexed views, user defined functions, triggers, and distributed queries. * Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling. * Installed and configured clustering i.e. active/active and active/passive. * Handful of experience in PowerShell Scripting. * Maintaining and Monitoring Production, Pre-Production and Development database server environment. * Ability to Build and maintain complex SQL queries for data analysis and data extract. * Strong experience working with stored procedures, database tuning methodologies, naming conventions, extraction, transformation and query methodologies. * Having Good Experience working with Onsite/Offshore Model. * Excellent Communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills. * Experience in providing 24X7 on call support on weekly rotation.