Sr. Database Application Dba/developer Resume
CharlottE
OBJECTIVE:
- A self - starting, innovative, construction, and result oriented professional, seeking opportunity to work as a SQL Server DBA.
- I am looking for a position in a growing Company, where I would find a unique opportunity to provide, invest, and prove my skills and expertise as a SQL Server Database Administrator.
SUMMARY
- Having 10 years of experience as SQL Server DBA Experienced in MS SQL SERVER 7.0,2000,2005,2008,2008 R2, 2012, 2014, 2016, 2017, and 2019 in implementing High availability like Log Shipping, Database mirroring, Replication, Always on availability groups and Clustering.
- Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Transactional & Merge Replication in SQL Server 2008/2005.
- Involved in Migrating MYSQL to SQL Server 2008 databases.
- Experience in installing and configuring SQL Server 2014/2012/2008 R 2/2008/2005/2000 SQL Server versions.
- Experienced in Installation, Configuration, Maintenance, and Administration of SQL Server 2017,2016,2014,2012,2008R 2/2008/2005/2000 /7.0 in standalone and clustered environments. Configured more than 2 GB RAM for 32-bit and 64-bit systems using AWE switches.
- Setup and configured AlwaysOn Availability Groups for DR and Reporting.
- Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
- Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
- Well versed in using several tools for project management, system & database architecture and Management Process developments.
- Verifying and tuning stored procedures created by developers by using Execution plans, SQL Server Profiler, Data Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
- Experience in administrative activates comprising Database health Check, Index optimization( Rebuild and reorganizing indexes with different fill factors and updating statistics.), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, data base security.
- Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).
- Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
- Used Erwin modeling tool for designing database objects.
- Development of Automated notification when SQL Server Backups and schedule maintained jobs.
- Migrated the SQL Server 2008 to SQL Server 2012.
- Migrated the SQL Server 2000/2005 to SQL Server 2012 and 2008 R2 versions.
- Used PowerShell script for SQL Server Maintenance activities.
- Handled very large databases (OLTP) which are in Terra Bytes (TBs).
- Expertise on physical storage SAN configuration on different RAID levels.
- Extensive experience in Deploying and Consolidating Remote Instances.
- Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
- Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
- Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
- Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
- Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
- Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
- Monitored Sybase data servers and replication server for performance.
- Migrated the Data from an External Sybase SQL to an MS SQL Database by using SSMA.
- Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
- Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
- Design and build database environments and solutions on both on-Prem and Cloud
- Administration, management, and monitoring of all PostgreSQL and SQL Server database systems.
- Installation and Configuration of PostgreSQL Cluster version 10.
- Creating and Managing PostgreSQL Databases.
- Managing user roles with configuration files, Access Control Lists and Row-Level Security.
- Multiversion Concurrency(MVCC) and Vacuuming of PostgreSQL databases.
- Managing the PostgreSQL.conf and pg hba.conf configuration and WAL log files.
- Database Roles and Privileges. PostgreSQL manages database access permissions using the concept of roles.
- Performed with success database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.
- Creation of PostgreSQL databases and configuration of rules in pg hba.conf file.
- Ability to thrive in a fast-paced, deadline-sensitive environment. Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
- Import of Reports to Aurora PostgreSQL from Oracle, Teradata, DB2 Databases.
- Installed and administered multiple VLDB Oracle 10g and 11g databases.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Installation and Configuration of Oracle databases 9i/10g.
- Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
- Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
- Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
- Object Level Audits using Change Data Capture (CDC).
- Managing database systems using Query Governor and Activity Monitor.
- Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
- Implementing efficient Database Design principles including Partitions and Compression techniques.
- Functions, Triggers, and Distributed Queries.
- Supporting SSIS, SSRS, replication, database mirroring, AlwaysOn availability groups, SQL Reporting Services, DacPac, BacPac, IsPac and deployments
- Experienced with Delphix to clone databases.
- Working with Azure Data Factory(ADF), Azure Databricks, Microsoft mobile device management (MDM)
- Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
- Testing methodologies and tools - Automation and Performance testing.
- 24/7 Production Databases on Call Support. Excellent Analytical, problem solving and communication skills.
TECHNICAL SKILLS
Databases: MS-SQL Server 2019/2017/2016/2014 , 2012,2008R 2/2008/2005/2000 , Oracle, MySQL, Sybase, DB2, MS Access
Languages: VB Script, Java Script, HTML, XML. T-SQL, C, C++, C#, VB.Net, JAVA, ASP.NET, Visual studio 2005/2003/2008/2010 , NET FRAMEWORK, ASP.NET, C#, MSOffice Suite, SharePoint, SAP, ERP
SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server. Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio 2005/2008/2010 , VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0, SSIS, SSRS, SSAS, SCOM, Tivoli TSM, SCOM, Foglight, MSBI, Power BI, Power Shell, PowerBI, VMware V6.0, VMware tools 10.3, Oracle Enterprise Manager, PowerBi, IBM Cognos.
Operating system: Windows 2012/2008/ 2003/ 2000/ Professional/ NT 4.0 Advanced Server
OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)
Load Test Tools: WAPT 7.5, WAPT Pro 3.1
PROFESSIONAL EXPERIENCE
Confidential, Charlotte
Sr. Database Application DBA/Developer
Responsibilities:
- Migrating SQL Server databases from SQL Server 2000/2005/2008/2008 R2 to SQL Server 2012/2014/2016/2017/2019
- Implementing always on availability groups and trouble shooting.
- Provides support for the further evolution of the data architecture for new and existing data warehouses.
- Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures.
- Manages the SQL server transactional database that collects data from our network of users.
- Ensure the server operations are functioning ontime and users are able to upload.
- Managing all technical aspects of the databases and processes.
- Working with SQL server 2012 and SQL server 2014, 2016 always on and multi subnet clustering.
- I Implement SQL Server high availability/DR solutions like Clustering, Database mirroring, Log Shipping and Replication·
- Supporting SQL server reporting service (SSRS), SQL Server Analysis Service (SSAS) and SQL Server Integration Service (SSIS)·
- Experienced with MSBI SSIS, SSRS, SSAS installation, troubleshooting, upgrade
- Working as Power BI Administrator
- Configuration, Admin, Power BI, Optimization
- Enable, configure andmaintain application, solution managerandDbase management
- Query performance optimization
- Installed SQL Server 2012 and configured Always on With Primary and secondary Replicas, Read only databases, listener and with Application Intent.
- Configured, tuned and maintained MySQL server database servers
- Monitored and modified Performance using execution plans with query hints and Index tuning.
- Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
- Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
- Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
- Performed horizontal data partitioning for efficient management of database tables and indexes.
- Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
- Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
- Working on different environments and a key resource for deployment of modified objects to production environments.
- Experience in writing scripts like retention of data using batch deletes.
- Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
- Incremental loading of dimensions, facts, error handling in SSIS.
- Created Dynamic SSIS packages, to load Stage tables from text files.
- Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
- Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
- Generated Script files of the databases whenever changes are made to stored procedures or views
- Backup Configuration of HANA systems running on Azure
- Troubleshooting the issues in SAP HANA Databases
- Performance tuning with SAP HANA Database.
- Working with Informatica cloud solutions, ZOS DB2, Netezza, DB2 LUW, Oracle 10g,11g, Mainframes JCL and ESPs.
- Working with Azure Data Factory (ADF), Azure Databricks, Microsoft mobile device management (MDM)
- Working with Python & Cassandra.
- Configured and managed virtual Servers and worked on virtualization and clustering environment.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
- Technical Analysis, Code Review, Implementation, 24 x 7 production support.
Environment: SQL Server 2017,2016,2014,2012,2008R2,2008,2005,2000, SAN, Windows Server 2016, 2012, 2008, 2003, clustering, Replication, Log shipping, Mirroring, Always on availability groups & SQL Sentry, Nagios, Lite speed, Net backup, EMC Networker (Legato), VB.NET, C#, ASP.NET, TFS, Visual Studio, PowerShell scripts, DTS, SSIS, SSRS, SSAS, E-Commerce, MSBI, SSAS, Cubes, Azure, AWS, Power Shell, Active Directory, Oracle, PowerBI, SAP, ERP, VEEAM, VMware, Unitrends, Attunity, SolarWinds DPA, Delphix, EMC Networker, DB2, MariaDB, MySQL, MongoDB, PostgreSQL, RDS, Redshift, Linux, psql, Json, shell scripting, SAP BW, SAP HANA, OEM, AWS Services, Data Pipeline, Glue, Kinesis, Redshift Spectrum, Azure Synapse, Splunk, VMware, Active Directory, Forest, LDAP, DNS, DHCP, Domain Controller, DevOps, PowerBi, IBM Cognos
Confidential
Database Administrator
Responsibilities:
- Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
- Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshot issues with the same. Applied hot fixes and Service Packs in clustering environments.
- Migrating SQL Databases from 2000/2005/2008/2008 R2 to SQL Server 2008R2/SQL Server 2012.
- Configured more than 2 GB RAM on 32-bit Environment.
- Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.
- Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
- Experience in Configuring, Managing and trouble shooting on SQL Server connection protocols like Kerberos and NTLM.
- Expertise in registering a SPN for Kerberos Connection and Performing NTML Failback.
- Implemented Kerberos Delegation with SSRS.
- Expertise in Fixed several Common issues in Kerberos and NTLM protocol like "Login Failed for user", "Could not open a connection to SQL Server", "Cannot generate SSPI Context", etc.
- Involved in migration of SQL 2005 TO SQL 2008r2
- Performed daily backups and developed recovery procedures
- Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
- Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
- Implemented and configured database monitoring tools and focused on providing a high availability database.
- Troubleshot issues with log file full and database size increasing beyond threshold.
- Creation of new database, planning the location of data, index, and transaction log files on the disks
- Involved in Capacity Planning, data modeling and Logical/Physical database Design
- Provided support to the application developers on the application databases
- Handled the database components of application releases
- Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.
- Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
- Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
- Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
- Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
- Configuring perfmon, blocking analysis, Enabling of AWE and PAE, Maxdegree Parallelism.
- Installation of SQLSERVER 2008,2008R2, SQL2012 service packs, hot fixes, Security patches, Lite speed.
- Practical experience in managing the internal and external MS SQL, SSAS database security
- Experienced with SQL, Oracle, APIs
- Experienced with Azure infrastructure setup, PaaS, Azure migration
- Worked with DR site setup, log shipping with on-prem and Azure
- Worked with multiple initiatives
- Setting up security measures across SQL Server instances with AD integration, Kerberos
- Installed, Configured, Worked with Fog light for SQLServer tool.
- Installed SQL Server instances and databases (including Service Packs), Upgrade SQL Server, SSAS (Service Packs)
- Worked with Oracle, DB2, MySQL.
- Experienced with E-Commerce, IBM DB2/LUW, Linux, Oracle, MySQL, PostgreSQL and Erwin.
- Worked with HADOOP
- Worked with Active Directory Services.
- Power Shell
- Worked with Red Hat Linux, Sybase DBA, IMS
- Mainframe Technologies (COBOL, CICS, DB2 and VSAM)
- Worked with ERP systems, SAP systems, system copy and Databases ERP, CRM, PLM, SCM, SRM, ERT, ECV, SAP S/4HANA
- Worked as a Database Engineer
- Experienced with VMware V6.0.
- Worked with VEEAM and Unitrends for backup and recovery.
- Scripting and automating solutions using PowerShell, Perl, T-SQL, PL/SQL, Python
- Worked in VMware latest versions
- Backup and restore with EMC Networker
- Knowledge on Upgrading Windows servers from .
- Troubleshooting and supporting Microsoft Windows Server 2008, 2012 in clustered configurations.
- Supported on Share Permissions for the respective folders of the new servers built.
- Configured Backup for all Test and PROD Servers.
- Application installation as per the scope of the team.
- Monitored the SQL disks and expand them to create enough room to store the SQL Data and Logs. Provisioning and configuring new servers for application deployments.
- Worked in Physical Server Migrations (P2P) by either Lift & Shift or build a new Server and provide assistance with DHCP/ Storage/ Data/ Permissions/ Printers/ ILO/ Cluster configuration and update for Data Center and Remote Site servers.
- Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
- Extracted data from various sources like SQL Server 2005/2008/2012 , Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
- Involved in all ITIL process like Change management, Incident Management & Problem Management.
- Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
- Developed and deployed stored procedures, created triggers and audits.
- Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
- Proactively monitored, determined and solved issues at sql/database/server levels.
- Handled 24/7 production issues.
Environment: SQL Server 2012, 2008 R2, 2K8 & 2005 with clustering, Replication & DBM, SCOM, VB.NET, C#, ASP.NET, SQL Sentry, Nagios, Lite speed, Net backup, PowerShell scripts, Fog light, Unix, TFS, Visual Studio, PowerShell scripts, SSIS, MSBI, SQL, SSRS, SSAS, Cubes, Power Shell, Oracle, SAP, ERP, VMware, VEEAM, Python, DB2, Splunk, VMware, Active Directory, Forest, LDAP, DNS, DHCP, Domain Controller, DevOps, BI tools, IBM Cognos.