We provide IT Staff Augmentation Services!

Sr. Sql Dba & Systems Administrator Resume

NJ

PROFESSIONAL SUMMARY:

  • Over 13+ Years of Extensive experience in Database Administration and Developer for very large and complex databases in SQL Server 2005/2008/2012 and 2014.
  • Excellent experience in Requirement analysis, Database Design, Development Testing, Migration, Reports Development, Documentation and Rollouts.
  • Excellent knowledge and experience managing application delivery right from requirements to Go Live
  • Expertise in Database administration on Production Servers with server configuration, Performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non - clustered environments.
  • Expert in trouble shooting and resolving SQL Server problems in line with the SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, Windows failover clustering, replication, Log shipping, Mirroring, Always On, backup/restore, database corruption, security and programming.
  • Expertise in Maintenance of databases, Performance Tuning and Troubleshooting.
  • Expertise in analyzing business needs and designing, Testing, implementing HADR models
  • Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
  • Expert level of Skills in Data Analysis, KPI identification and dash boards design
  • Extensive experience in developing reports and dashboards using Crystal Reports, SSRS & Tableau
  • Extensive work experience on SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Experience in Installation, configuration and maintenance of SQL Server 2000/ 2005/2008/2012 and 2014
  • Expert in Data migration using SSIS and DTS services across different databases includes Oracle, MS access & flat files.
  • Exposure to complete life cycle of software development
  • Experience Design, development and Testing of software applications using Visual Studio 6.0,C# .Net
  • Experience in writing Distributed Queries using different heterogynous data sources in SQL Servers.
  • Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
  • Expert in developing navigating reports, filtering reports, Formula Work Shop based Reports using Crystal Reports and SSRS.
  • Good Business and System analysis skills to understand the requirements and customize client applications.
  • Experience of working on different RDBMS like Oracle, MYSQL, SQL Server and MS Access.

TECHNICAL SKILLS:

Operating Systems: Win 9x/NT/XP/ 2000/2003/2008/2012/2014

RDBMS: SQL Server 7.0/2000/2005/2008/2012/2014 Oracle 11i, MYSQL and MS Access

Languages: Visual Basic 6.0, Visual Studio .Net,C# .Net T-SQL, PL/SQL

Web Technologies: ASP, VB Script, HTML, MS-Front Page, IIS

Development Tools: MS Visual Studio 6.0/. NET, VB.NET, VB 6.0, DTS, SSIS

Reporting Tools: Reports 8/10/XI, SQL Reporting Services (SSRS), SSIS, SSAS, Tableau

Configuration Tools: MS Visual Source safe, CVS, MS-TFS

Tools: & Utilities: Erwin, JIRA, i.Assist,e-Support, BMC, ITSM, SSMA, Redgate

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. SQL DBA & Systems Administrator

Environment: SQL Server 2014, Conterra, IIS, Tableau 10.5

Responsibilities:

  • Support for Database Administration Tasks including Configuration Management, Backup/Recovery, Performance Optimization, User management and space management of Production and Testing environments.
  • Installation and Configuration of SQL Server in various environments.
  • Working with development team in issue fixing issues, patches installation and script execution
  • Trouble shooting query performance working with Stored Procedures and Indexes
  • Managing Production, Development and Testing environments deploying scripts and db changes
  • Created Stored Procedures and Triggers for Business functions
  • Created weekly maintenance jobs for DB consistency check and Rebuilding Indexes
  • Users and Security Management
  • Created Daily, Weekly and Monthly Backup Jobs
  • Created and scheduled jobs for automatic moving of old DB files
  • Performs Backup/Restore Verification on regular intervals on various environments
  • Set up and managing Transaction Replication and Troubleshooting Replication issues
  • Monitoring Daily/Weekly Backup and maintenance jobs
  • Configured Database Mail and Users
  • Creates Database Diagrams for specific functionalities for End user Training
  • Created and Scheduled Monthly Backup and restore jobs for System Databases
  • Performs code review on specific business stored procedure and shares best practices with Developers
  • Verify and installation of SQL Server Patches and Service Packs.
  • Development and schedule for daily import jobs using SSIS
  • Installation and configuration of FieldClix System
  • Installation and configuration of FieldClix mobile app
  • Onboarding/Off boarding employees/users/customers
  • Development, Testing and Implementation of Project Templates
  • End User Training for Project Managers
  • End User Training for Field Employees
  • Users Access and security management
  • System Libraries Management
  • Developing reports
  • End user support
  • Mobile Devices Registration
  • Profile Configuration & Deployment
  • Remote Monitoring & Support & Trouble shooting
  • Requirement Gathering & Analysis
  • Design, Development and Testing of Reports
  • Daily Reports upload
  • Report Publishing to Key users

Confidential, SFO

Sr. SQL DBA

Responsibilities:

  • Managed Production, Development, QA and UAT environments
  • Experienced in troubleshooting long running queries and resolving locking and blocking issues
  • Involved in migration from SQL Server 2005 to 2016.
  • Developed and Scheduled ETL packages using SQL Server Agent
  • Designed and maintained Unified Database model
  • Populated data from various data sources creating packages for different data loading operations for ETL application.
  • Worked on Setting up and managing Snapshot and Transaction replication.
  • Implemented AlwaysOn Availability Groups for high availability and disaster recovery
  • Resolved issues related to creating & maintaining of databases, monitoring Disk Space, Database Security, Database integrity, Indexes management, blocking and daily checks.
  • Setup & Automated Key Alerts on daily/weekly maintenance Jobs, Data Loads Jobs, Disk Space and CPU Monitoring,
  • Monitored server performance, trouble shooting and fixing performance issues
  • Developed complex business stored procedures, function and triggers
  • Extensively used SQL Server DMV's for Performance Tuning
  • Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
  • Created Backup, Restore and Verify strategy for production and development environment.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
  • Working with development teams in design, validate and development of database schemas and objects
  • Backup, Restore and verify the critical databases on regular intervals.
  • Validate and executing the scripts in test, UAT and Production environment.
  • Installation, configuration and upgrade of MS SQL Server 2012/2016
  • Capacity planning and setting up environment for new applications
  • Updating Service packs and Security patches for the Servers.
  • Analyzing data, Defining KPIs and publishing dash boards
  • Preparing technical documentation and presentations on DB schemas, DB models and best practices

Environment: Database: SQL Server 2012/2014, MSQL,MS Access, Windows 7, 2008/2012

Confidential, Houston, Texas

Sr. SQL DBA - Lead

Responsibilities:

  • Requirements Collection, Analysis and Client interaction
  • Handling the DB team size of 8
  • Around 400 databases servers maintenance and implement the change control requests
  • Provide consultation on SQL Server questions/issues to development teams
  • Installing, configuring, administering and securing development and production servers using SQL Server 2008R2 and SQL Server 2012
  • Create automated processes/jobs to automate repetitive tasks
  • Configure linked server & remote server to execute remote procedures
  • Performed daily tasks including regular database and servers health check
  • Standardize the process across all the environments
  • Troubleshooting server outages, as well as troubleshooting and monitoring job failures Along with application issues
  • Create and schedule Database maintenance plans
  • Configure Mirroring and log shipping on development and testing servers
  • Configure Always on SQL server 2012 on development and production servers
  • Perform the Multi server administration
  • Generation of Traces and diagnose the same in order to find out the performance bottle necks
  • Responsible for applying patches by service pack installation and hot fixes
  • Providing after hours on call support
  • Providing necessary recommendations on the HW and SW upgrades
  • Updating DB/Server/Jobs/Users/Roles artifacts on regular intervals
  • Comparing Schema/data in various environments while trouble shooting
  • CR’s Management
  • Work Allocation/ Monitoring/Review and ensure On time delivery
  • T-SQL Programming
  • Coordinating with development team in terms of developing queries, stored procedures.
  • Monitoring Block and locks and resolved the issues.
  • Taken preventive measures in order to avoid performance issues.
  • Review of work progress with team
  • Attending Review Meetings with client
  • Sending status reports to client as mutually agreed.

Environment: O/S: Windows 7/2003, Server 2005/2008, BMC, Redgate, SQL, Oracle 11i,MS Access

Confidential

Architect & Sr. DBA

Responsibilities:

  • Implement and maintain high availability strategies via log shipping, transactional replication, and clustering. Conduct disaster recovery exercises and ensure maximum up time with minimal latency between Active/Active data centers.
  • SQL server cluster shared environment (Active\Passive).
  • Created Database maintenance plans for Backup and Recovery.
  • Prepared data migration plan and developed scripts
  • Designed, developed, tested and implemented database archiving engine for production databases
  • Performance monitoring and fixing of critical dash boards
  • Created complex Stored Procedures, Packages, Triggers and Scheduled Jobs.
  • Dynamic Queries to address complex business logics involving in multiple Databases.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Created Stored Procedures and T-SQL Queries for SQL Server reporting services (SSRS).
  • Migrated Data Transfer Service (DTS) Packages to SQL Server Integration Service (SSIS).
  • Created Bulk Insert Packages to Retrieve Data from Flat Files using SQL Server Integration Services (SSIS).
  • Analyzing new Report requirements and designing specification documents.
  • Creating Reports from large Database using SQL server Reporting Services (SSRS).
  • Created parameterized Reports using charts, Matrix, List, Sub Reports, and Running Totals using SQL Server Reporting Services (SSRS).
  • Created Cascading Reports link giving hyperlink to a field and that will takes u to the another report or chart using SQL Server Reporting Services.
  • Responsible for performance tuning, optimizing the queries (TSQL statements), removing redundant and inconsistent data, joins from the database tables and normalizing them
  • Rewrote TSQL queries, removed unwanted columns, established joins and created indexes wherever necessary
  • Providing updated DB scripts for Schema and Data during Build preparations
  • Prepared documentation/scripts for tables, stored procedures, SSIS tasks and comprehensive commenting of all codes. Maintained technical documentation for operational support
  • Pre-sales support, Technical Proposal preparation and support
  • Customer relations management, Invoicing, and Receipts Management
  • Acting as single point of contact in reaching Tech Mahindra for all the business and technical requirements
  • Team Management and resource allocation for various new requirements
  • New business requirements, Analysis, identification and allocation of team.

Environment: Database: SQL Server 2005, Oracle 11i,ASP.Net, C#.Net, IIS, CTI,AVLT, GIS O/S: Windows XP/7, 2003,2005, SSIS, SSRS

Confidential

Database Architect

Responsibilities:

  • Requirement Analysis
  • Data Modeling (Logical & Physical)
  • Brainstorming with project teams on the proposed Database design
  • Standardizing the SQL coding practices across the projects
  • Logical and physical designing of Databases and documentation
  • Writing T-SQL code, Stored Procedures, Views, Functions and Triggers
  • Migration of Master data
  • Monitoring and Maintaining Development and Testing servers
  • Training the development teams on the SQL coding standards
  • Installation and configuration of development and testing servers
  • Review/recommendation on critical business functionality
  • Query optimization, performance tuning
  • Participating in project review meeting
  • Participating in domain and technology meetings
  • Publishing weekly report on DB development progress
  • Publishing ‘Tip of the Day’ for all the projects team
  • Managing and appraising DBA Team
  • Code review, and re-writing the critical SPs
  • Designing, Testing and configuration of suitable HA & DR models.
  • Conducting training session for project teams on the new features and best practices

Environment: Visual Studio 2010, ASP.net and IIS, Windows 7, 2008,SQL Server 2005

Confidential

Team Lead & Sr.DBA

Responsibilities:

  • Databases and Servers Monitoring
  • Managing and supporting 24/7 production activities
  • Team Lead and Shift lead
  • Configuring and managing Log-shipping, Replication for development servers
  • Configuring and managing database mirroring for production servers
  • Performance monitoring and tuning
  • Security Management of Servers and Database
  • Index Management
  • Scheduling and monitoring Jobs
  • Backup and restore/verify activities
  • Deadlocks and Blocks management
  • Disk space management
  • Patches and service packs installation
  • Installation and configuration of SQL DB servers
  • Planning & execution of weekly Maintenance activities
  • Co-coordinating with project team on the deployment activities
  • Stakeholders management
  • Generation of ad-hoc reports and dash boards

Environment: Visual Studio 2010, ASP.net and IIS, Windows 7, 2008, SQL Server 2005

Confidential

Database Administrator

Responsibilities:

  • Leading the Database Team
  • Working with Development team for database design and development
  • Monitoring and maintaining 4 production and 3 development servers
  • Job Monitoring & publishing
  • Creating and Scheduling new Jobs
  • Monitoring disks statistics on production servers
  • Monitoring and sending reminders to team on CVS Difference and Data Integrity Checks.
  • Creating and maintaining users in Windows as well in SQL Server
  • Creating environments for testing
  • Verifying the Backup files status
  • Providing support to Client on Day-to-day activities on the product.
  • Creating and scheduling Windows Schedulers
  • Coordinating with onsite support team
  • Coordinating with CapGemini team for the Infrastructure support.
  • Logging and resolving issues that are raised by client on the MDM product.
  • Monthly maintenance of Address Doctor Database
  • Following Defect tracking and analysis (JIRA)

Confidential

Sr. Developer

Responsibilities:

  • Analysing and Fixing the Production issues assigned through JIRA
  • Preparing RCA documents
  • Acting as primary contact to the first line support.
  • Getting clarification from the client through first line support
  • Installing, configuring, administering and securing database servers
  • Writing Stored Procedure, T-SQL queries and UDFs
  • Applying the DB scripts in Testing and UAT environments
  • Troubleshooting performance issues and fine-tuning queries and stored procedures
  • Backup and recovery management
  • Production support through on line quarries
  • Preparation of Build Request Documents
  • Preparation of scripts and data for production rollouts
  • Build support and performing smoke test
  • Allocation and follow-up of tasks status with the team.
  • Change Request Management
  • Dealing with VSS for any code changes
  • Preparing Unit Test Cases, Code Review Report Documents
  • Updating the online defect tracking system for the issues delivered
  • Supporting QA team
  • Participating in weekly/monthly/quarterly review meetings
  • Publishing status reports to PM

Environment: C#.net, IIS and Crystal Reports 8.5, SQL Server 2000, Windows XP, 2000s

Confidential

Module Lead

Responsibilities:

  • HIS Implementations at customer locations
  • Installation and configuration of database servers
  • Application installation, Setup and configuration
  • Maintenance and support Production Databases and servers
  • Demonstration of existing applications and features
  • Preparation of functional gap reports
  • Requirements gathering and analysis
  • Preparation of technical documentation
  • Code development using VB and T-SQL
  • Unit, System, Integration and Functional Testing
  • Reports Development using Crystal Reports and Printer Objects
  • Creating and scheduling jobs and maintenance activities
  • Interacting with customers, vendors for Integration and support
  • Designing and Developing integration engines for external accounting systems
  • Preparation of user manuals, installation documents and end user training guides
  • End user training and assessment
  • Writing Stored Procedures, Triggers and UDFs
  • Creating and updating tables
  • Configuration and managing database replication on production server
  • Query optimization, performance tuning
  • Performing daily check activity on the production servers
  • Environment setup for development, testing & UAT
  • Analysing Change request and preparation of FD, TD and DB documents
  • Preparation of Impact analysis documents on the Change Requests
  • Monitoring and Maintenance of Database servers
  • Backup and restore databases

Environment: Windows 97/NT, SQL Server 2000, VB 6.0, COM/DCOM and Crystal Reports 8.58

Hire Now