We provide IT Staff Augmentation Services!

Senior Sql Server Database Administrator Resume

4.00/5 (Submit Your Rating)

New York, NY

TECHNICAL SKILLS:

Languages: T - SQL, PowerShell, C#, C++, ASP.NET, VB.NET

Systems: Windows 2008 R2/2012 R2/2016 and Linux

Database: SQL Server, Oracle, MS Access

Software: SQL Server Management Studio, Visual Studio, RedGate, VMware vSphere, CA Arcserve, Oracle PL/SQL, SQL Developer, Toad, Informatica, ipMonitor, MS Office

Methodologies: SDLC Agile, Waterfall, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior SQL Server Database Administrator

Responsibilities:
  • Serve as SQL Server Database administrator executing installation, configuration, maintenance, upgrade, patching, deployment, and backup/recovery for SQL Server 2005/2008/2008 R 2/2012/2014/2016.
  • Install, configure, and upgrade SSRS, SSIS, SSAS, TFS, Windows Server, SharePoint Server, and Project Server.
  • Implement High Availability using SQL Server Always On, Failover Cluster, Replication, Mirroring, and Log Shipping.
  • Performance tuning, query optimization, troubleshoot issues, capacity management and hardware purchases.
  • Serve as DBA in the completion of 100+ medium to large scale implementations and managing projects from business requirements analysis to solutions delivery and support.
  • Manage a data-integration project for financial services group that consolidated information from third-party market data vendors’ flat files (Bloomberg, Thomson Reuters, Markit, S&P, FTID, Moody’s, etc.) into SQL Server.
  • Design and implement a robust Data Warehouse with SQL Server storing billions of historical records consolidated from third-party Market data vendors.
  • Design and develop table structures, stored procedures, indexes, triggers, functions, views, jobs and SSIS packages for various projects.
  • Administer and monitor SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, and end user and ensure the availability of the Database Server in a 24x7 Environment.
  • Implement VMware vSphere, Veeam backups, virtualizes existing hardware, and experimenting in Microsoft Azure.
  • Implement programs/scripts to automate backend tasks using C#/PowerShell.
  • Train new hires from IT and Technical department and leading IT/development projects.

Confidential, Secaucus, New Jersey

Software Engineer/ DBA

Responsibilities:
  • Served as SQL Server Database administrator who executed T-SQL coding, created tables, stored procedures, indexes, triggers, functions, jobs, backup/recovery databases.
  • Facilitated database configuration in order to improve the performance and reliability of the SQL Server.
  • Designed and developed WinForms applications to display, update, delete, and data reporting from SQL Server databases.
  • Designed and developed FTP scheduling system with enhanced SQL performance, allowing business analyst the ease to store vendor FTP information ranging from HTTP, HTTPS, SFTP, FTP and FTPS. The system can validate connections, monitor, re-run or schedule tasks to run at a specific time and repeated in intervals.
  • Designed and developed C# ASP.NET group-scheduling system for the firm, allowing employees to view and post availability and vacation data for resource allocation purposes.

We'd love your feedback!