We provide IT Staff Augmentation Services!

Senior Database Administrator & Developer Resume

Santa, MonicA

PROFESSIONAL SUMMARY:

  • Over 16+ years of professional software industry experience. Involved in all phases of SDLC like Requirement gathering, Analysis, Design, Development, Implementation, Testing, configuration management and change management
  • Very good experience in Installation, configuration and maintenance of SQL Server.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Experience with backend programming using T - SQL, Stored procedures, user defined types and functions, triggers, views on SQL Server databases. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Experience in Database backup and disaster recovery procedures.
  • Experience in Database Design, Development, Administration, Maintenance, Tuning, Backup, Restores, Log Shipping, Replication, Failover Clustering, AlwaysON for SQL Server 2016, 2014, 2012, 2008, 2005 and 2000 databases.
  • Strong in SQL, Transact SQL, ETL, DTS, SQL Server SSIS, SSAS and Visual basic, C# Dot Net.
  • Deep understanding of SDLC (Life Cycle), multi-Tier, Object Oriented Design and Distributed Architecture.
  • Created DTS Packages for Data Migration and Transformation. Experience in data migration from Access/Excel/CSV to SQL Server 2005/2008/2012/2014/2016
  • Experience with ODBC interface to SQL Server and other databases.
  • Experience includes working with front-end applications such as Visual Basic, VBScript, Java Script, HTML, C#.
  • Working with MS Office Tools like MS-Word and MS-Excel for management reporting.
  • Executed projects in various domains i.e. Banking, Inventory, Warehouse.
  • Has the ability to work in a fast paced environment, Good team player and can work independently.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016, 2014, 2012, 2008, 2005, 2000, MySQL, Redshift, DynamoDB

Technologies: Visual Basic, COM, ASP, XML, HTML, Java Script, VBScript

PROFESSIONAL EXPERIENCE:

Senior Database Administrator & Developer

Confidential, Santa Monica

Responsibilities:
  • Setup and Installation of SQL server 2016 and 2014
  • Responsible for disaster recovery planning for SQL Servers. Implemented SQL Server HA, Log Shipping
  • Creation of SQL Server Jobs for automation of SSIS packages to be executes daily, weekly, monthly basis and creating Alerts to monitor Success/Failure of ETL jobs.
  • Creation and Administration of new ETL SSIS packages for importing data from multiple files, other databases to the SQL Server database, data mapping and creating Zip files and Importing/Exporting files using File Transfer utility in SSIS.
  • Creating Scripts in ETL for dynamic file name loading and automation.
  • Development of SQL stored procedures, Views.

Senior Database Administrator & Developer / Project Manager

Confidential, Burbank, CA

Responsibilities:
  • Managing SQL Servers ranging from 10gb to 1.3TB database servers
  • Setup and Installation of SQL server 2014, 2012, 2008, 2005.
  • Numerous Successful and seamless migrations from older SQL Server versions to the newer ones.
  • Set up SQL Server Failover Clustering on top of Windows 2012 Cluster on SAN infrastructure to minimize down time and data loss.
  • Responsible for disaster recovery planning for SQL Servers. Implemented SQL Server Log Shipping and Replication for high availability of member accounts.
  • Setting up of Database Mirroring and Manual Failover plan.
  • Databases Capacity planning and monitor database growth with the help of DMVs and online third party scripts and creation of capacity metrics.
  • Development of SQL stored procedures, Triggers, Views. SQL Server Replication setup.
  • Rewriting and tuning long-running SQL queries to cut execution time, ease database load and improve scalability.
  • Reviewed and optimized SQL queries, stored procedures, views and triggers from application developers to achieve maximum efficiency and scalability.
  • Monitor SQL Server Profiler on regular basis to optimize slow running queries and stored procedures and debug issues. Performance Tuning of SQL Server, Tuning of the database involves checking of system resource usage using the performance monitor, SQL Server Profiler, choosing efficient indexes, optimizing queries etc.
  • Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS and SSIS packages.
  • Creation of SSIS packages for importing data from flat files to the SQL Server database and creating Zip files and Exporting files using File Transfer utility in SSIS.
  • Monitoring and automations of daily tasks through SQL Server jobs.
  • Created company intranet for SQL Server Reporting, MIS, fulfillment, tracking, data Entry

SQL Server Developer/DBA

Confidential, Los Angeles, CA

Responsibilities:
  • Database designing in SQL server 2000.
  • Monitoring and giving 24x7 support for DTS packages and incremental load.
  • Performance Tuning of SQL Server, Tuning of the database involves checking of system resource usage using the performance monitor, choosing efficient indexes, optimizing queries etc.
  • Development of SQL stored procedures, Triggers, Views. SQL Server Replication setup.
  • Responsible for disaster recovery planning for SQL Servers. Implemented SQL Server Replication for constant availability of customers accounts.
  • Preparation and reviews of functional specifications, technical specifications, various interface specification documents.
  • Developing various middle tier components, front End GUI for the CitiAlert application.
  • Involved in development, deployment and support of CitiAlert application for US businesses.

Hire Now