We provide IT Staff Augmentation Services!

Database Administrator/developer Resume

Bellevue, WA

SUMMARY:

  • 6 + years of extensive experience in Planning, Installing, Configuring, Testing, Migrating, Maintaining, Administering MS SQL Server 2016/14/12/08 on a Standalone & Clustered Servers.
  • Proficient in designing & developing Databases involving Normalization/De - normalization, Stored Procedures, Queries, Views, Triggers, User Defined Functions, etc.
  • Proficient in writing T-SQL statements: DDL, DML, DCL, TCL
  • Expertise in Disaster Recovery, Backup, Query Optimization, Performance Monitoring, Tuning and Troubleshooting T-SQL Query issues.
  • Working knowledge of SQL Server Azure (PaaS &IaaS), Amazon Web Services technologies.
  • Proficient in using SQL server Performance Monitoring Native and Third-Party Tools.
  • Expertise in performing Maintenance Tasks, Scheduling & Automation of Jobs
  • Experience in Configuring & Monitoring Log shipping, Mirroring, Replication, and AlwaysOn.
  • Experience with Windows Clustering, VMware, Firewall, AD, Configuration of IIS.
  • Expertise ETL across heterogeneous platforms including SQL Server, MS Access, and flat files.
  • Understanding the concept of DWH: Star and Snowflake Schemas, Dimension& Fact Tables.
  • Provide support for the design, configuration and maintenance of SSRS, SSIS, and SSAS.
  • Expert in Software Development Life Cycle (SDLC), Agile and Waterfall Methodologies.
  • Strong analytical & problem solving skills coupled with interpersonal and communication skills.
  • Provide 24X7 mission critical support for production environment to achieve business goals.

TECHNICAL SKILLS:

IDE: Visual Studio 2015/2012/2010/2008/, SSMS 2016/14/12/08 /2005

MS BI Stack: SSRS, SSIS, SSAS

Languages: SQL/T-SQL, C#, PowerShell

Web Applications: HTML, XML, CSS, JavaScript

Source Code Control & Testing Tools: TFS, QC, Git, Selenium, Bugzilla, Octopus

Applications/OS: MS Office Suite, Windows Server 2012/R2/2008R2/7,Windows 10/8/7

Third Party Tools: Spotlight, Redgate, LiteSpeed, Idera, Splunk, SQL Search, Beyond Compare

Data Modeler: Visio, ER Assistance

PROFESSIONAL EXPERIENCE:

Database Administrator/Developer

Confidential, Bellevue, WA

Responsibilities:

  • Installed, configured, maintained and administered MS SQL Servers 2016/2014/12/08
  • Configured High Availability Features: Log shipping, Mirroring, Replication, and Clustering.
  • Administered backup and recovery of all databases and systems.
  • Designed and managed databases, tables, views, indexes, procedures, triggers, constraints, etc.
  • Reviewed codes for optimizations and suggested indexes for Dev team.
  • Used PefMon, SQL Server Profiler, and Activity Monitor to troubleshoot performance issues.
  • Used third party tools to monitor and troubleshot Sql server performance issues.
  • Monitored & resolved database spaces, CPUs, Memories, connectivity issues.
  • Performed Database Encryption implementation for protecting different data.
  • Performed ETL to transform data from different sources to SQL Server DB and vice versa.
  • Managed SQL Logins, roles, users as part of Security Policies.
  • Performed maintenance tasks and automated SQL server jobs.
  • Used PowerShell script to start & stop services, backup and restore databases.
  • Created SSIS Packages, Supported configuration and maintenance of SSRS, SSIS, and SSAS.
  • Configured, restarted and stopped Internet Information Server (IIS).
  • Participated in the different phases of SDLC, STLC, testing methodologies.
  • Researched & recommended SQL server technologies effective to meet business goals.
  • Participated in project & business requirement meetings.

Environment: SSMS 2016/14/12/08, Windows10/8/7, Windows Server 2012/R2/2008.

SQL Database Administrator

Confidential, Seattle

Responsibilities:

  • Create Stored Procedures, Triggers, Functions, Indexes, Tables, Views, other T-SQL code.
  • Perform SQL Server data migration, installed and configured sql server 2012.
  • Monitor database space, performance issues, CPU, memory and connectivity issues.
  • Setup monitoring alerts for SQL jobs failure/long running jobs and data validation.
  • Perform database back up, restore and recovery on test, production & development server.
  • Monitor SQL server objects & counters using SQL Profiler, DTA, and Perfmon monitor.
  • Upgrade an instance from SQL Server 2005 to 2008 using side by side.
  • Document all the processes involved in maintaining the database for future references.
  • Create and maintain users’ security permissions and resolved the issue of orphan users.

Environment: MS SSMS 2012/ 08/R2, Windows 7/Vista/XP, Windows Server 2008/03.

SQL Database Administrator

Confidential

Responsibilities:

  • Create database objects, tables, views, index, stored procedure, functions, sql joins and updates.
  • Responsible for data migration from SQL Server 2005 to SQL Server 2008
  • Configure, monitor and troubleshot Replication, Log Shipping & Mirroring
  • Perform database backup and restore, recover database and scheduled jobs.
  • Monitor database growth & plan for data storage and servers, schedule jobs.
  • Create and manage database objects including tables, views, indexes, constraints
  • Created logins, users and security groups.

Environment: MS SQL Server 2005/2008, Windows 2003/XP, Windows Server 2003.

Hire Now