We provide IT Staff Augmentation Services!

Database Administrator And Developer Resume

New York, NY

SKILLS:

Languages: T - SQL; Visual Basic; ASP .NET; C++; UNIX Shell Scripting

Environment: SQL Server 20 14/2012/2008 R2; Windows Server 2008R2/2012 Enterprise Edition; MongoDB

Applications: Windows PowerShell; VMware ; Active Directory; IBM Cognos BI ; Framework Manager and Data Manager; Pervasive Data Integrator ; Git, Redgate

EXPERIENCE

Confidential, New York, NY

Database Administrator and Developer

Responsibilities:

  • Install, configure and maintain SQL Server 2014/ 2012/2008R2/2005
  • Implement and manage mirroring, replication, log shipp ing , clustering, and AlwaysOn.
  • Build, maintain and monitor scheduled processes that include SSIS packages, SQL Maintenance Plans and SQL Agent jobs executed both on demand and on schedules for backups, ETL and application functionality.
  • Develop and maintain ETL processes in IBM Data Manager, SSIS and Pervasive Data Integrator for the data warehouse. Reconcile processed data with source system for completeness and accuracy.
  • Build and maintain meta data model in IBM Framework Manager for the data warehouse.
  • Design, implement and maintain highly customized relational database solutions in SQL Server.
  • Collaborate with Product Managers, Project Managers, Business Analyst and various business groups.
  • Implemented SQL server security best practices and transparent data encryption (TDE)
  • Work on database integrity by performing backups, consistency checks, and performance monitoring.
  • Work on optimizing query, tuning stored procedures and performance monitoring with developers

Confidential, New York, NY

Database Administrator

Responsibilities:

  • Involved in upgrading multiple instance of environments of SQL Server 2000 to SQL Server 2008 to SQL Server 2012.
  • Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Migrated databases and database objects between multiple servers across production, QA and development platforms.
  • Involved in resolving locking and blocking issues.
  • Maintain policies, procedures and technical documentation of all database systems .
  • Perform data profiling on new and existing source data prior to logical and physical modeling. Audit data quality and advise stakeholders of potential challenges.
  • Develop and maintain ETL processes in IBM Data Manager, SQL SSIS and Pervasive Data Integrator for the multiple heterogeneous OLTP systems and data warehouses .
  • Build and maintain meta data model in IBM Framework Manager for the data warehouse.
  • Responsible for Disaster Recovery Planning, Backup and Restoration, log shipping, user rights management Configuring and administering jobs and DTS/SSIS packages.
  • Create logins & grant access to users as per requirement, creating and providing access to database application roles.
  • Responsible for modifications and corrections to the database via help desk system.
  • Discreet handling of sensitive and confidential information such as patient healthcare records, employee records and payroll.

Confidential, Long Island City, NY

Software Developer

Responsibilities:

  • Design, develop, code, test, debug, modify & document applications using C++.
  • Provides comprehensive configuration file management solution based ATM networks .
  • Provide design recommendations for unit & integration testing in Quality C enter.
  • Develop new functionality, modify existing configuration files and simulates an virtual ATM software environment

Confidential, NY

Assistant Network Engineer

Responsibilities:

  • Set up, test, and evaluate systems such as local area networks, wide area networks, the Internet, intranets, and other data communications systems.
  • Perform network modeling, analysis, and planning, which often require both hardware and software solutions.

Hire Now