SUMMARY

• Confidential is a Database Administrator and Database Developer/Engineer with 9+ years of experience in delivering database support, database migration, data analysis, database automation and database security in the financial, commercial (retail) & manufacturing industry.
• Solid experience in Administrating, Maintaining, Optimizing, and Supporting SQL Server Databases with up to MS SQL Server 2019 in Production, Development, QA/Staging and Data Warehouse Environments.
• Proficient in AWS services like VPC, EC2, S3, RDS, ELB, EBS, IAM, CloudFormation, Route 53, CloudWatch, CloudFront, CloudTrail, Amazon Redshift.
• Architect, design and support Cloud - based infrastructure and its solutions.
• Extensive experience in designing and implementing High Availability features and Disaster Recovery plans of the MS SQL Enterprise databases in SAN and Cluster Server environment.
• 7+ Years of experience in Data Migration using various tools (DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).
• Extensive experience in configuring, maintaining, and troubleshooting SQL Transactional, Snapshot and Merge Replication and Log Shipping.
• Optimizes application data models for performance, manageability, scalability, and availability.
• Data warehouse architecture, dimension modeling and metadata management.
• Expertise in identifying and improving long running SQL queries and tuning PL/SQL and T-SQL codes, identifying options for improving performance using SQL profiler, SQL Server Performance Monitor, Activity Monitor, Database Tuning Advisor, Dynamic management view, and Query Execution plan.
• 6+ Years of experience working with EMC storage and with other SAN boxes.
• Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company Security Policies.
• Extensive experience in Performance tuning queries, stored procedures and long running queries
• 8+ Years of experience in configure and support SQL server reporting Services (SSRS) and SQL server Integration Services (SSIS).
• Strong knowledge in using DMVs and DMFs to find and solving Performance Issue, Data modeling concepts.
• Experience in PowerShell scripts for SQL Server Maintenance activities and builds and releases.
• Expert in server virtualization using VMware Hyper V and cloud technology using AZURE and EC2.
• Extensive use of SQL Server Performance Monitor to identify potential bottlenecks (CPU, Memory, File I/O, Locking, blocking, or deadlocking) affecting SQL Server.
• Manage client priorities, expectations and maintain knowledge of industry trends in database systems, recommend implementation of new or evolving technologies, presenting the business case for creating a new database system or using a new technology.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills as well as flexible to learn advancements in the IT industry.

TECHNICAL SKILLS

Database: MS SQL Server, AWS RDS, Redshift, DynamoDB, MySQL, IBM DB2, Oracle, Teradata

SQL Server Tool: SSMS, SSIS, SSRS, SSAS, Enterprise Manager, Profiler, Query Analyzer, DTS, VS

Languages: T-SQL, C#, ASP.Net, SQL, PL/SQL, MDX/DMX, UNIX Shell

Operating System: Windows, Linux

Third Party Vendor Tools: Alteryx, Argent Job scheduler, IDERA tool, SQL Sentry, Dell Spotlight, Net Backup, SQL Query Analyzer, SQLsquirrel, Redgate, AppDynamics, PagerDuty, Epicor, Salesforce, ServicePRO, JIRA, Rubrick, GitHub, Aptos POS, Octopus

Cloud Services: MS Azure, Jenkins, Kubernetes, EC2, EKS, S3, IAM, Route 53, VPS, CloudWatch, SignalFX, Datadog, Logz, Snowflake

PROFESSIONAL EXPERIENCE

Confidential, Olympia, WA

Lead Database Administrator

Responsibilities:

• Primary responsible for highly volume transactional database, providing production systems support as part of an on-call rotation and support off hours releases.
• Performs overall database architecture, design, installation, configuration, Azure DevOps technical support, and maintenance of the MS SQL Enterprise databases in a SAN and Cluster Server environment.
• Supervision and Manage staff of 3 DBAs and controlling all database environments in L&I units.
• Create and maintain scripts for task automation and execute data transformations in various system integrations.
• Provides application development support for Query Optimization, Stored Procedures, Triggers, Indexes, etc. for multiple development applications.
• Manages the administration of storage management, security, and audit management for enterprise-wide databases and handling third party vendor licenses.
• Implementing and administering multiple instances with always on high availability groups and transaction replication for production reporting databases.
• Administering SQL Server on standalone/clustered servers with tasks including database backups, agent job management, provisioning security, installation, patching, Azure DevOps and configuration.
• Evaluate multiple criteria such as business objectives, growth trends, compute resources to develop and maintain capacity plan for database and application platforms.

Confidential, Washington

Senior Database Administrator

Responsibilities:

• Developed and implemented backup/recovery procedures, conducting periodic tuning of the databases, capturing and reporting database usage statistics as required, monitoring space usage, allocating disk space, and providing technical support as needed.
• Designed master Kenworth DataMart ETL packages to load, PAAS IAAS, transform and extract data from MS SQL to Teradata and Snowflake.
• Tuned Server, Databases and Applications Performance by analyzing various metrics gathered using PerfMon and Data Collector by implementing industry best practices.
• Automated daily and weekly system and database maintenance tasks.
• Managing and maintaining AWS IAM policies to define groups, Kubernetes create users, assign roles, and define rules for role-based access to AWS resources.
• Locking/blocking and poor performing query issues with SQL Profiler and DMVs.
• Upgraded ETL packages from 2008 to 2017 using SSIS and created master central repository for all Kenworth ETL packages.
• SLA’s and SLI’s project, defined business standards monitor, alerts and reports.
• Supported development team and implemented SQL joins, Azure DevOps sub queries, database objects such as Triggers, stored procedures, functions, tables, views and Constraints and advise option to utilize
• Installed Active-Active on SQL Server 2017 failover cluster on 64-bit Windows Server 2016/2012 R2 cluster Physical & Virtual environment.
• Performance monitoring to identify potential bottlenecks of CPU, Memory, C Sharp, File I/O, Locking/blocking, and deadlocking that affecting prod SQL Servers.

Confidential, NYC, NY

Database Administrator

Responsibilities:

• Primary responsible to manage and monitor all cloud based and on premises instances in Production environment and give 24/7 on-call support.
• Maintaining, Implementing, and supporting MS SQL Servers, Azure Power shell Amazon RDS, Aurora Databases performance.
• Implemented and supported developers for database objects stored procedures, UDFs, views, triggers, upgrade scripts.
• Worked on AWS services with IAM, CloudFormation, AMIs, SNS, EC2, EBS, S3, RDS, VPC, ELB, IAM, Route 53, Security Groups.
• Pushed changes to databases and applications via a scheduled release methodology. Applied escalation and notification procedures for incidents. Handled major & high- profile deployments & upgrades.
• Implemented Always On availability groups for 3 replicas on Windows failover cluster environments.
• Worked with Data Center Operation group, Kubernetes Site Reliability and Database Reliability engineer group to provide daily escalation access and cleanup unnecessaryroles/permission.
• Worked on DevOps/Agile operations process and tools area like Code review (Git repository), unit test automation, Release automation (CI-CD), Service, Incident, Azure DevOps and production Change Management.
• Created DBA “run books” that contained detailed information about every SQL Servers covering the applications/databases supported by the server, the stakeholders for each application/database with their contact information, backup/recovery methodology, Azure DevOps hardware, and software configurations.

Confidential, Long Island, New York

Senior SQL Database administrator

Responsibilities:

• Configured, supported, and maintained APTOS POS Application V6.4 and managed IBM DB2 database objects.
• Implemented High Availability and Disaster Recovery solutions with SQL Server Log Shipping and Failover Clustering (Active-Passive).
• Performed migration from MS SQL Server 2008 R2 to 2017 and Carried out Installation, Patching, Upgrades, migration and performed troubleshooting of database related issues during upgrading and migration process.
• Used SQL profiler, system monitor, Azure DevOps query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and T-SQL code.
• Automated daily and weekly system and database maintenance tasks as database backup, database integrity, database stats and database indexing.
• Maintained change control and release management process for all production database objects like tables, views, procedures, and triggers.
• Created Linked Servers between SQL Server to Oracle databases, AS400 database.
• Worked on ALTERYX tool to Analyzed data, Azure Power shell blended them, prepared, and designed for business
• Wrote and Optimized Stored Procedures, Views, and User-Defined Functions for the application.
• Monitored application performance using Appdynamics tool and managed/handled productions incident using PagerDuty tool.

Confidential, San Francisco, CA

Database Administrator

Responsibilities:

• Supported high volume financial transactional databases in multiple geographical locations in the US and provided 24*7 support, including business continuity solution, backup/restore, disaster recovery and performance tuning.
• Managed over 300+ MS SQL Server with high volume of data and Maintained 55 mission critical applications.
• Created and Authored SQL Server Hardening ‘Run books’ for Production environment and Documented for server security, database standard policies and procedures.
• Implemented database Transparent Database Encryption at Rest (TDE).
• Implemented SQL Securities and managed permissions through the Database roles, creating users and logins, troubleshot, and supported technical issues and worked on Active directory Azure DevOps to manage user account passwords, permissions, and roles.
• Implemented Linked Server and linked logins securities and resolved linked server issues.
• Performed migration from SQL Server 2008 R2 to 2014 following the Normalization standards to maintained data consistency and Carried out Installation, Patching, and Upgrades on Development, UAT and Prod environments.

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Responsible for logical and physical data modeling, Designing Database, star schema, data analysis, programming, documentation, and implementation.
• Configured and maintained SQL transactional replication, and merged replication on prod reporting servers.
• Performed SQL instance version upgrades from SQL 2005 and 2008 to 2012.
• Created a SQL Batch Job of the same and maintained to the optimal needs.
• Managed SQL Server Installations, patching and configuring databases for developments and testing servers.
• Developed automation of maintenance jobs, tuned SQL Server locks and indexes configurations, administered SQL Server security.
• Performed the migration from SQL server 2005 to SQL 2008 following the Normalization standards to maintain data consistency.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Implemented Disaster Recovery for minimal downtime using backups, Azure Power shell restore, and replication.
• Upgraded SSIS Packages from SQL Server 2005 to SSIS packages in SQL Server 2008 database.

Confidential

SQL Developer and Database Administrator

Responsibilities:

• Developed and documented the Server and database migration process including scripts to correct deprecated and de-supported features using T-SQL syntax.
• Optimized slow running SQL server queries on production Servers and performance tuning queries.
• Performed database index tuning and optimization.
• Monitored SQL agent job failures for production and non-production SQL Server environment including servers.
• Built installation solutions for SQL Server 2008 and 2012 instances.
• Developed and created Maintenance plan solutions for protecting the SQL Server databases on all SQL environments.
• Capacity planning for SQL Servers.
• Developed standards for database backup, maintenance, and database recovery.