We provide IT Staff Augmentation Services!

Sql Server Database Administrator/ Aws Consultant Resume

2.00/5 (Submit Your Rating)

Bakersfield, CA

SUMMARY

 
  • Hands on Experience in Amazon web services Like IAM, EC2, EBS, S3, RDS (SQL Server) Cloud watch and CLI tool.
  • Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2019/2017/2016/2014/2012/2008 R 2/2008/2005.
  • Expertise & Hands on experience on SQL server migration activities from SQL 2000/ 2005/2008/2008 R2 to SQL 2012/2014/2016/20017.
  • Experience in building policies for access control and user profiles using AWS IAM, S3 controls with bucket policies.
  • Expertise in Querying RDBMS such as SQL Server and RDS.
  • Expertise in DMS activities such as on - premise SQL server to AWS Aurora Postgres and Redshift.
  • Expertise in DMS activities such as on- premise Oracle databases to AWS Aurora Postgres and Redshift.
  • Expertise in DMS activities such as on- premise PostgreSQL to AWS aurora Postgres and Redshift.
  • Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.
  • Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
  • Expert in RDBMS software installation, database server builds, applying patches, applying patches in VM environments (VTM), upgrading, configuring, troubleshooting of SQL SERVER on Windows 2003/08/12/16 servers and Clustered VMware Environments.
  • Expertise in new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture.
  • Knowledge in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
  • Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
  • Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
  • Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
  • Hands on experience in troubleshoot the tempdb growth and configuration settings.
  • Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
  • Excellent skills in database Backup, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
  • Hands on experience using DMVs and DMFs to finding and solving Performance Issue.
  • Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
  • Expert in creating and debugging Views, Functions, Indexes, Cursors, Stored Procedures, Triggers, optimizing code and improving Efficiency.
  • Basic knowledge in MongoDB database architecture and Primary components.
  • Good knowledge & experience on Cloud Computing like Azure/AWS
  • Expert in migrating the DTS Packages to SSIS Packages by using Package Migration Wizard.
  • Worked Extensively on ETL process using SSIS packages.
  • Expertise in configure the PerfMon and Extended Events to troubleshoot the performance issues.
  • 24/7 on call production support.
  • Hands on experience on ITIL process.
  • Experience in Server administration in various environments - Window 2000 & 2003 with Active Directory Services (AD, DNS, DHCP).
  • Experience in In-Place upgrade of Windows serves from 2008 R2 to 2016.
  • Expertise in automating the system by using System Center Operations Manager (SCOM).
  • Hands on experience on configure the Solarwinds DPA alerts.
  • Basic knowledge on SAP ME/MII application.
  • Thorough understanding of Windows OS as well as Powershell scripting and Active Directory integrations with SQL Server.
  • Expert in raising the Service Requests and keep tracking of requests.
  • Good Team player, Strong Communication skills and interpersonal with Self-motivation.

TECHNICAL SKILLS

Relational Databases: SQL Server 2019/2017/ 2016/2014 / 2012 / 2008 / 2008 R2/Postgres/Oracle

Database Tools: SSMS, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, DTA, PerfMon, Extended Events, ADO, ADO.NET, Business Intelligence Studio(SSISLanguages: C#, XML,HTML, SQL, T-SQL

Operating Systems: Windows 2016, Windows 2012, Windows 2008R2, Windows 2003, UNIX. AWS EC2.

Web Servers: IIS 5.0/6.0/7.0, Amazon web services (AWS), Virtual Private Cloud (VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Cloud Computing AWS: (EC2, ELB, S3), Azure, AWS Elasticache, Cloud Formation, Cloud Watch, CloudTrail, IAM, CloudFront, Glacier, Route53, RDS, DMS.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor. Active Directory, SQL Navigator, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint,, Site Recovery Manager (SRM), SAP ME/MII., Terraform, Ansible

PROFESSIONAL EXPERIENCE

Confidential - Bakersfield, CA

SQL server Database Administrator/ AWS Consultant

Responsibilities:

  • Understanding the architecture and design of on premise applications before designing and architecting AWS infrastructure for configuring, building and deploying the application.
  • Automating the implementation using Ansible scripts so that the entire application is configured, built.
  • Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
  • Experienced in creating RDS instances to serve data through servers for responding to requests.
  • Created snapshots to take backups of the volumes and also images to store launch configurations of the EC2 instances.
  • Written Templates for AWS infrastructure as a code using Terraform to build staging and production environments.
  • Managed Amazon redshift clusters such as launching the cluster by specifying the nodes and performing the data analysis queries.
  • Worked on the databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
  • Implemented Amazon RDS multi-AZ for automatic failover and high availability at the database tier.
  • Created CloudFront distributions to serve content from edge locations to users so as to minimize the load on the frontend servers.
  • Worked on migrate the data from on- premise SQL server208R2 and SQL server 2016 to AWS PostgreSQL.
  • Analyzed source table designed through Aws Schema Conversion tool and Identified data type issues, fixed the same and created those tables in AWS PostgresQL and Redshift.
  • Involved in troubleshoot the DMS task failures and worked on those tasks.
  • Worked on Migrate the data from On-primase Oracle databases to AWS Aurora PostgreSQL and Redshift.

Environment: AWS (EC2, VPC, ELB, S3, EBS, RDS, Route53, ELB, Cloud Watch, CloudFormation, AWS Auto Scaling, Lambda, Elastic BeanStalk), SQL, AWS CLI,, Shell scripting,Terraform, Postgresql,Oracle10g.12c, SQL server 2008R2,2016

Confidential, Denver - CO

SQL server Database Administrator Consultant for Data maintenance and Performance tuning

Responsibilities:

  • Installed and configured SQL server 2012/2014 with AlwaysOn 2 replica.
  • Working on MS SQL Server 2012/2014 and responsible for installation, configuration and provided 24 X 7 supports to all production Servers.
  • Created and migrated partially contained databases within AlwaysOn Availability Groups.
  • Responsible for Performing SQL server upgrades, conducting performance analytics, and tuning and system sizing and configuration on SQL server version 2012/2014.
  • Monitor SQL instances and logs and take corrective actions if problems arise.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Responsible for Identify problematic tables and prepare Implementation plan for cleanup the tables.
  • Created database tables based on SAP MII application functionally.
  • Created user defined stored procedures to run multiple transactions in limited duration on SAP MII application.
  • Worked on design triggers for automatic executions after user committed transactions.
  • Created User defined functions based on SAP MII application requirement.
  • Created Views and Synonyms to collect the sales data for Reporting Purposes.
  • Configured SQL JDBC connections between database servers and SAP MII application servers.
  • Worked on Import the application required data to databases from SAP MII application binary file systems.
  • Work on database development activities on Development environment and subsequently make changes on Quality and Production environments.
  • Worked on ITIL process to implement the make database changes on each environment (I,e Development, QA and Production environment).
  • Work on provide the SQL database accesses to respective stakeholders and share the credentials in encrypted format.
  • Developed and Rewrote T-SQL queries for better performance.
  • Worked on Security issues dealing related to logins, DB users, and application roles and linked Servers.
  • Configured the automatic database maintenance jobs for continuous monitoring.
  • Monitor the database server’s performance through performance counters and SQL Native tools.
  • Analyzed long running queries and create the indexes and recommend for query tuning.
  • Used SQL Profiler to find badly performing queries and deadlocks.
  • Involved is setting up maintenance jobs related to SQL server health checks and Application health checks.
  • Work on query analysis and ensure locking and blocking should not occur during parallel process.
  • Analysis the SQL query execution plan and duration and if any significant changes find the root cause and resolve the issue.
  • Capture column fragmentations and work on for column defragmentation.
  • Develop auto rebuild, re-organize and update statistic maintenance jobs for column defragmentation.
  • Actively worked on review and monitor SQL servers and Instance resources to insure continuous database operations (I.e, database storage, memory, CPU, network usage and I/O contention).
  • Involved in all Deployment phases (I,e D1,D2A,D2B and D3) to streamline the plants are in-line with SAP MII application requirements.
  • Work on make changes on SQL database objects (I,e tables, Stored procedures, functions) per application requirements on Development environment and subsequently move to Quality environment.
  • Developed and maintained various complex T-SQL, Powershell scripts for various DBA related tasks.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Actively worked on test the required changes on QA environment and move same changes to Production environment.
  • Work on establish the connectivity with database server and SAP MII application.
  • Work on troubleshoot the production issues and find out the root cause analysis.
  • Perform the database development activities in tables, stored procedures and functions during cutover and application maintenance window in each deployment phase servers as required.
  • Create SQL server instances on SQL server 2014 version and databases with appropriate initialization parameters and database structures.
  • Check for the database maintenance failed jobs, investigate the route cause analysis and resolve the issue.
  • Implemented and provided the design plans for the new SQL Server 2014 concepts like New In-Memory OLTP Engine, Enhancements to Backups and Buffer pool extension.
  • Co-ordinate with respective stakeholders and SAP MII application team and identify the records with respective column key parameters within the respective table (I,e Delta changes) between each Deployment phase.
  • Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
  • Compare and Identify delta changes on during each deployment.
  • Work on import the same delta changes on required databases.
  • Work on identify and cleanup the data that not require further after discuss with SAP MII application team for better performance.
  • Work as part of a project team to coordinate database development and determine project scope and limitations.
  • Worked on troubleshooting critical performance, space, availability and various issues using TSQL/Powershell.
  • Plan coordinate and implement security measures safeguard production and sales order data against to unauthorized users.
  • Support to SAP Basis administrator team while configures the SAP MII application for providing database level input parameters.
  • Read the ERD diagrams and understand on primary key and foreign key relationship and column relationship between the tables.
  • Troubleshoot the issues on configure the SAP application with respective database level.
  • Work on Third party application vendors to understand the application functionality and provide recommendations and feedback to Leadership team.
  • Attend troubleshoot calls and resolve the issues during Hypercare.
  • Support responsiveness to outages and issues.
  • Collaborates with developers/application designers in solving critical defects of application before release dates.
  • Developed a .bat file to shrink the log file after successful log backup file job completed on Cummvalut.
  • Excellent communication skills, both written and verbal are required for this position.
  • Perform other tasks and duties as assigned by supervisor.
  • Monitor the day to day transactions from Solarwinds DPA and Identify T-SQL long running queries.
  • Installed application on AWS EC2 instances and configured the storage on S3 buckets.
  • Amazon IAM was used to maintain the user credentials and also involved in creating custom IAM policies to various groups defined within the organization.
  • Created SQL native backup jobs in AWS IaaS environment servers.
  • Scaled distributed in-memory cache environment in the cloud using Elastic cache.
  • Configured and scheduled the scripts to automate the module installation in the environment.

Environment: SQL Server 2005/2008R 2/2012/2016/2017/2019 , T-SQL, Windows Server and SAP Manufacturing Integration and Intelligence, AWS, Cloud Watch, S3, EBS, EC2, RDS, DMS, EC2, Cummvalut, Microsoft Azure and SQL Azure.

Confidential

SQL Server Database Administrator for Migration project

Responsibilities:

  • Installation, configuration and upgradation of SQL server 2012, SQL servers 2014 and SQL server 2016 on Windows 2008 and Windows 2012 based on Enterprise Distributed Security (EDS- IBM) standards.
  • Installed and configured SQL Server 2016 and higher versions. Configurations built and supported should include scenarios that include leveraging SQL AlwaysOn and Windows failover clustering
  • Upgraded/migrated the several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
  • Prepared the documentation and implemented the Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
  • Involved Disaster Recovery excise and got CREDO awarded.
  • Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
  • Implemented best practices for system and data administration functions for complex, multi-system, multi-platform network on Windows, UNIX and Linux based platforms.
  • Migrating the Database from SQL server 2000 to SQL server2008 and from SQL server 2008 to SQL server 2012/SQL server2014 on SIT/DEV/QA/PRODUCTION region.
  • Migrated the DTS packages from SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages incoordination.
  • Configuring of SQL Server 2014 new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
  • Used multitask data pump in DTS/ETL.
  • Assist with database transaction and security audits.
  • Troubleshoot and problem solving of SQL related issues, including advising on customer issues.
  • Reviewed T-SQL code and maintaining coding standards in all SQL Server environments.
  • Hands on configuring Tempdb with considerable Memory and Raid Levels for better performance.
  • Creating and Maintaining Trace Audits for Security events.
  • Involved in the meetings with Line of Business for requirements gathering and modified procedures according to the business requirements.
  • Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
  • Created and Modified existing functions and procedures based on business requirements.
  • Setting up Connection Strings and connecting SQL Server Databases from application front.
  • Configured SSIS and SSRS packages on sql server 2014 and moved the packages and tested them.
  • Involved on application migration activities from windows 2003 to windows 2012.
  • Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service on Azure environment as a part of SQL server 2014 and SQL server 2016.
  • Provided support on .net\java application migration activities on Windows 2012R2 operating systems.
  • Provided 24*7 on call support.

Environment: SQL Server 2005/2008R 2/2012/2014/2016 , T-SQL, Windows Server, HTML 4.0, JavaScript, Access, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), DB2, Microsoft Azure and SQL AzureConfidential

SQL Database Administrator

Responsibilities:

  • Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
  • Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
  • Managed the database objects like Tables, views, indexes.
  • Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
  • Worked on moving Data in and out of Windows Azure SQL Databases and Blob Storage.
  • Backing up entire user’s database and scheduling backup process.
  • Successfully resolved deadlock issues by creating traces objects using SQL Server Profiler.
  • Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Installed and configured MySQL on Linux and Windows environments.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
  • MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
  • Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1.
  • Implemented SQL Server high availability solutions including clustering, Always-on replication, log shipping and Symmetric Remote Data Facility (SRDF).
  • Worked in Active/Passive and Active/Active cluster environment.
  • Responsible for installations, upgrades, patches and fixes.
  • Export and Import of data from text files and Excel to SQL Server database using Bulk Copy Insert and BCP utility
  • Setup profiler traces for slow running queries and used query execution plan to optimize the performance and improve I/O utilization.
  • Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring and RAID technology.
  • Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler
  • Monitored performance and current space utilization reports to management along with recommendations for any corrective action.
  • Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler
  • Monitored performance and current space utilization reports to management along with recommendations for any corrective action.
  • Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications
  • Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
  • Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
  • Responsible for migration of databases from one version to other versions and applying patches.
  • Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
  • Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
  • Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2005 for achieving performance enhancement.
  • Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
  • Actively participated in gathering of User Requirement and System Specification.
  • Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.

Environment: Windows Server 2008R2/2012R2, HTML 4.0, JavaScript, Access, Microsoft Azure and SQL Azure. SQL Server 2005/2008/2008 R2/, T-SQL,

We'd love your feedback!