Senior Sql Server Dba Resume
SUMMARY:
- Microsoft Certified IT Professional (SQL Server 2008)
- Microsoft Certified Database Administrator (SQL Server 2000)
- Microsoft Certified in Installation and administration of Windows 2000.
- Microsoft Certified in Programming and development in ASP.NET using VB.Net.
- ITIL Certified (2018)
- 14 years overall experience in the IT industry with a strong understanding of the business process.
- Excellent communication skills and a Team Player as well as a Team Leader.
- Over 12 years experience in Database Administration,
- Expert level skills in Database sizing, Backup/Restore, mirroring, Log shipping, Data Import/Export, Data Modeling (Physical and Logical), Capacity Planning, Installation and Configuration, Upgrades, migrations, tuning, troubleshooting, security
- 1 year of experience in Cognos, creating the Catalogs and implementing the Security using User Classes in Impromptu Administrator, creating Power Cubes, Powerplay reports, ReportNet, Cognos, and Impromptu Web Reports (IWR) using databases such as Oracle, MS SQL Server, MS Access, MySql, Sybase and PostGreSQL
- Working knowledge of Oracle 8i/10g,11, Java, Vmware, Clusters, Datastage and Informatica
SKILL:
Skills: Unix, Windows NT/ 2000/2003/2008
Databases: MS SQL Server 7.0/ 2000/20 /2017 , Oracle 8i,10g, postgresql, sybase
ETL: MS DTS, Informatica and Datastage, SSIS
Reporting tools: Cognos suite (Impromptu Administrator, Transformer, Visualiser, Access Manager, Power Play), Business Objects, Crystal Reports, SSRS administration
Design Tools: Erwin, Visio
Other tools: Double take, spotfire, orion, Diagnostic manager, TFS, SQL Safe, Insight, Great Plains, Redgate, ServiceNow, Remedy, Deskpro
Infrastructure: Vmware, SAN, Windows clustering
PROFESSIONAL EXPERIENCE:
Confidential
Senior SQL Server DBA
Responsibilities:
- Maintain and monitor about 20 SQL Servers ( versions 2008/2008 R 2/2012/2014/2016/2017 )
- Manage and administer Great Plains application
- Lead the patch management process - Quarterly review of all applications and servers for patching
- Provide 24/7 support all days
- Install and configure Spotfire and scribe applications
- Migration of data from SQL Server to Oracle
- Install and configure Biovia tools.
Confidential, Jersey City, NJ
Senior Database Administrator
Responsibilities:
- Maintain, monitor and tune over 75 SQL Servers ( 2000/20 ) in Production Environment and 250 in other environments
- Provide 24/7 support on a weekly shift basis
- Installation and configuration of SQL Server 2005 as per business rules
- Configuring and supporting Always ON clusters
- Migration of databases between different versions of SQL Server
- Capacity planning for new Servers
- Monitor space on a daily basis to ensure that its not crossed the business specified threshold
- Lead, monitor and participate in server replacement projects
- Installed, configured and administered Sql Server Reporting Services
- Ensure that the newly created environments and the existing environments are Sox compliant.
- Setup scripts to mimic log shipping as a solution for DR environment in Canada branch
- Analyze and execute requests in Production Approval System, Remedy
- Documentation review and maintenance
- Provide support for ad-hoc requests and issues
- Take part in Audit meetings, implementation and solutions so as to ensure that the environments complies with SOX and other audit requirements
- Provide review of SQL Server Environment for auditing
- Lead the patch management process- review monthly patch releases and submit a sign off listing patch details, and its review to upper management
- Assist fellow DBA and developers in day to day issues and queries
- Configure third party tool - Insight, in order to remotely monitor all SQL, Oracle and Sybase production environments
- Initiate, organize and participate in BCP testing and documentation
- Create linked servers to Oracle servers as and when requested
- Configure and maintain Database mirroring in order to create a DR environment
- Backup Oracle DBA with ad-hoc requests or issues when required like import/export using datapump, add logins, unlock logins, shutdown databases, and restart databases.
Confidential, Princeton, NJ
Consultant Senior SQL DBA
Responsibilities:
- Plan, chalk out, execute and support multiple data migration projects. Some of the migrations involved merging of 3 systems into one with a tight time constraint.
- Ensure that the
- Installation, configuration and administration of 30 SQL servers.
- Architect Always ON Availability Groups solution for HADR.
- Ensure that the newly created environments and the existing environments are HIPAA compliant.
- Respond and resolve ad-hoc issues escalated from Level 1 support
- Documentation of new system
- Create back up and DR strategies for all new and existing systems(Always ON Availability Groups)
- Performance tuning on the production databases.
- Configure database Mail and ensure that all jobs have notifications setup.
- Write scripts for reporting, for analysis as well as to help co-workers manupilate data.
- Automate the process of creating appointment reminders for the automatic calling system
- SQL Server to MySQL migration.
Confidential, Parsipanny, NJ
Consultant Senior SQL DBA
Responsibilities:
- Maintain, monitor and tune over 35 SQL Servers (2005/2008/2012 ) in Production Environment
- Provide 24/7 support all days
- Provide support for ad-hoc requests and support to development and business team
- Install, configure and create jobs for full server protection using Double Take
- Automated Index optimization as part of performance tuning efforts
- Move log, data and system files to separate drives.
- Installed, configured and administered Sql Server Reporting Services
- Create stored procedures, views, triggers to retrieve audit activities and provide proof to show compliance
- Manage change control with weekly release of stored procedures, views, triggers and ssis packages
- Work with network admins, system admins, change control admins resolving any production issues
Confidential, Philladelphia, NJ
Consultant Senior SQL DBA
Responsibilities:
- Analyze and document the hardware and software configuration of the current environments
- Create a checklist to inculcate the current server configuration in the target environments
- Install, configure and patch the new servers
- Create project plan to migrate the servers
- Create scripts to migrate the databases
- Ensure that the newly created environments and the existing environments are HIPAA compliant.
- Use Double Take to sync the databases from source to target
- Create cutover plan
- Migrate databases as per plan
- Support UAT and cutover Testing
- Used Tools like Idea Diagnostic Manager, Double Take, SQL Safe throughout the project lifecycle.
Confidential, Princeton, NJ
Consultant Senior SQL DBA
Responsibilities:
- Maintain, monitor and tune over 15 SQL Servers (2005/2008/2012 ) in Production Environment
- Provide 24/7 support on a weekly shift basis
- Provide support for ad-hoc requests
- Provide day to day support to development team
- Migration of databases in the End Of life Project for 4 servers.
- Installed, configured and administered Sql Server Reporting Services
- Monitor Memory usage on a clustered server with several instances.
- Document the current Production environment
- Involved in the initial process to get an outline for new clustered environment.
- Service broker setup and configuration
- Created databases, database objects, stored procedures, views, triggers, ssis packages on request
- Configure Log shipping
- Analyze and plan a new clustered environment to house existing as well as new instances.
- Plan for the migration of databases from existing environment to new environment
Confidential, Jersey City, NJ
Senior Database Administrator
Responsibilities:
- Maintain, monitor and tune over 45 SQL Servers (2000/2005/2008 ) in Production Environment and 150 in other environments
- Provide 24/7 support on a weekly shift basis
- Installation and configuration of SQL Server 2005 as per business rules
- Migration of databases between different versions of SQL Server
- Capacity planning for new Servers
- Monitor space on a daily basis to ensure that its not crossed the business specified threshold
- Lead, monitor and participate in server replacement projects
- Installed, configured and administered Sql Server Reporting Services
- Setup scripts to mimic log shipping as a solution for DR environment in Canada branch
- Analyze and execute requests in Production Approval System, Remedy
- Documentation review and maintenance
- Provide support for ad-hoc requests and issues
- Take part in Audit meetings, implementation and solutions so as to ensure that the environments complies with SOX and other audit requirements
- Provide review of SQL Server Environment for auditing
- Lead the patch management process- review monthly patch releases and submit a sign off listing patch details, and its review to upper management
- Assist fellow DBA and developers in day to day issues and queries
- Configure third party tool - Insight, in order to remotely monitor all SQL, Oracle and Sybase production environments
- Initiate, organize and participate in BCP testing and documentation
- Create linked servers to Oracle servers as and when requested
- Configure and maintain Database mirroring in order to create a DR environment
- Backup Oracle DBA with ad-hoc requests or issues when required like import/export using datapump, add logins, unlock logins, shutdown databases, and restart databases.
Confidential, Parsipanny, NJ
Senior MS SQL DBA
Responsibilities:
- Create, monitor and maintain over 10 SQL Servers (2000) in the new Production, Test and Development Environments
- Infuse meaningful data into the test and development databases from the existing databases
- Enhance the new schemas after the analysis of existing schemas
- Created disaster recovery and backup plan
- Handled security and connectivity issues
- Verify backups and error logs on the servers and troubleshoot any failures or alerts.
- Respond and resolve every day issues and requests, if required to work with other team members from other departments
- Primary on call support duties during the rollover period
- Work with network admins, system admins, change control admins resolving any production issues
- Chart out the execution plan for the rollover period, and ensure that all teams adhere to the plan.
- Monitor the progress of the project with respect to the project plan at hand.
- Ensure that the dead lines for each of the projects and their phases are met in a timely and organized manner
- Actively involve and participate in team meetings and author how-to documents and knowledge base articles for various database related tasks
- Actively involve in meetings involving vendors, clients, testers, developers and upper level management.
- Setup backup and recovery jobs based on the business policy
- Consolidated and upgraded various small applications running on Access 97 to use SQL Server 2000/2005 as backend database
- Plan the layouts for the new SQL Server Boxes which would be hosting new applications
- Worked with the developers to ensure the timely completion of the projects
Confidential, NYC, NY
Senior MS SQL DBA
Responsibilities:
- Reverse engineer the legacy schema
- Analysis of the new schema
- Created a strategy for data extraction, translation and migration
- Formed a policy to handle data insufficiency and data redundancy
- Propagate changes called for by the changes implemented in the on going development of the new application.
- Create test plans to ensure that the data in the new schema is current and in sync with the new Application
- Upgrade databases from SQL Server 2000 to SQL Server 2005
- Creating Build and Patches for different conversion Version and applying them as needed.
- Handle security and connectivity issues
- Coordinate the different tests such as functionality, vulnerability, UAT etc.
- Implemented scripts on the Production Servers
- Create a data dictionary and additional documentation on the Current database and the new database
- Document the options for executing and testing the scripts for future use
- Create reports to reflect data required by upper level management for day to day purposes