We provide IT Staff Augmentation Services!

Senior Sql Server Dba And Developer Resume

5.00/5 (Submit Your Rating)

Gardena, CA

SUMMARY

  • Senior SQL Server DBA with 10+ years of hands - on experience in SQL Server implementation, maintenance, administration and 24x7 support.
  • He possesses very strong analytical skills and is an expert problem identifier with the ability to work both independently and as a team player to solve them.
  • He is able to resolve complex business related challenges methodically yet in a cost-effective and data-driven manner.
  • He is able to quickly adapt new technologies and learn programing languages necessary for problem solving.
  • He is effective and precise in verbal and written communication skills, presentation and interpersonal skills.
  • He has worked in various industries such as internet and technology, property management and retail, and supported SQL Server versions 2005/2008/2008 R 2/2012/2014.
  • Hands on experience on High Availability/Disaster Recovery (HA/DR) solutions; Failover Clustering and AlwaysOn Availability Groups, Log Shipping, Replication and Mirroring.
  • Expert in installation, configuration, maintenance, and optimization of SQL Server Database Services, Analysis Services, Integration Services, Reporting Services and implementing/supporting HA/DR solutions.
  • Expert in Performance Tuning, Troubleshooting, Query Optimization, Security and Disaster Recovery. Standardizing SQL environments and implementing best practices.
  • Expert in Upgrading/Migrating/Patching of MS SQL Server 2000/2005 → 2008/2008R2 → 2012/2014.
  • Expert in backup and restore of databases; automated or ad-hoc using native and/or third party tools.
  • Expert in monitoring health and performance of SQL servers, as well as, home grown applications using SQL Server native tools and several other third party solutions.
  • Expert in T-SQL, creating/debugging/optimizing stored procedures, tables, indexes, views, functions, and triggers. Application script development per business need. Expert in automation.
  • Expert in creating SSIS packages to utilize SSIS functionalities and ETL operations, SSRS and T-SQL.
  • Created numerous complex T-SQL SPs/scripts, C# and backend apps to leverage automations, reporting including backend support for new applications with error handling. Worked extensively with SSIS and SSRS to solve company needs.
  • Worked extensively with SQL Server and Windows Security and Network. Experience with partially contained databases and DB dependency resolutions.
  • Expert in using SQL Server Utility/Extended Events/PerfMon/SQL Profiler/Tuning Advisor/Execution Plans/Scripts and other third party tools to resolve bottlenecks, dead locks, slow running queries and performance tuning.
  • Fully familiar with Data Warehouse and Data Mart concepts, implementation, optimizations. Able to leverage existing DWs data from SaaS or in-house implementations to solve business problems.
  • Responsible for securing SQL Servers, user management, assigning granular permissions and creating roles. Applying best practices across the board to standardize and minimize database security risks.
  • Able to benchmark and load-test new instance builds for performance with DB load simulators, or capture performance baselines.
  • Expert in VMware and Hyper-V virtualization, Hardware/Software Clustering, RAID and SAN/NAS technology.
  • Strong System Administration background in both Windows and Linux environments. Intimate knowledge of Windows Operating Systems and technologies including PowerShell.
  • Experience in creating technical documentations, diagrams and process archiving, and change management.
  • Experience in project management, working independently as well as in team-oriented environments and with third party vendors. Ability to coach and mentor team members as needed, and effectively and professionally communicate with supervisor or other team members.
  • Expert in problem solving, analysis and conflict resolutions as well as finding alternative solutions.
  • Experience in supporting and maintaining large databases and troubleshooting their problems.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, .NET platform, WPF, Java, JavaScript, PERL, ASP, PHP and XML, XAML/HTML

ETL Tools: SSIS, BI (BIDS/SSDT), Visual Studio (all versions).

Data Modeler: SQL Developer Data Modeler, Oracle Data Modeler, TOAD, MySQL Workbench.

Reporting & Audit Tools: SSRS, Visual Studio, Idera SQL Compliance Manager and SQL Secure.

Backup Software: SQLBackup, LiteSpeed, Redgate SQL Backup Pro, Idera SQLSafe, etc.

RDBMS & Tools: SQL Server 2005/2008/2008 R2 and 2012, MS Access 2003/2007/2010/2013 Oracle 11g, Oracle Data Modeler, MySQL 5.0, PowerShell.

Operating System: Windows 95/98/XP/Vista, 7, 8, 10, Windows NT/ 2000/2003/2008 and 2008R2, 2012 servers, and RHEL, CentOS. Ubuntu, Fedora, VMware and Hyper-V virtualization.

Third Party Tools: RedGate suite, Spotlight, IderaSQLDM, Toad Development Suite, phpMyAdmin, Ola’s Maintenance Scripts, Iometer, PuTTY, Wireshark.

DB Query/Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer, Toad for SQL/MySQL/Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Gardena, CA

Senior SQL Server DBA and Developer

Responsibilities:

  • Guided team to deliver data management and system integration between Enterprise Resource Management (ERP), Point of Sale systems (POS), Warehouse Management System (WMS) and eCommerce platforms - High Jump (Supply Chain Management System), Counterpoint (POS System), KWI (Retail Management System) and Market Live/Kibo Commerce (eCommerce Platform)
  • Overcame company’s hurdle of not being able to leverage business data that accumulated on remote read-only public cloud and disparate SaaS environment where the only means of data analyses available to them was off-the-shelf reports. Implementation of his solution was recognized as the most important value add to the company as it enabled them to develop custom reports unavailable to them previously tailored to their specific needs and opened the doors to several other solutions related to retail and inventory management.
  • Developed a data warehouse analogue and complex SQL scripts that automated and enhanced company’s merchandising department’s weekly, monthly and quarterly sales data calculations and aggregations of various sales metrics for analyses and projections. This indispensable solution alone, which was served through SSRS, saved that department hundreds of man hours quarterly that were spent previously manually generating these metrics from excel templates and off-the-shelf reports.
  • Developed custom Order Management System (OMS) for ecommerce team using SQL Server native tools which incorporated complex warehouse decision logic based on customer orders and inventory availability at all store/warehouse locations to streamline and fulfill order allocations automatically.
  • Responsible for leading data cleanup efforts throughout disparate database systems, vendors systems, conflict resolution and overseeing integration points
  • Responsible for creating, deploying, automating and troubleshooting SSIS packages (BI Solutions) and SQL or C# .NET scripts as needed for ETL and optimization of data including company’s data mart.
  • Maintenance, support and enhancement of company’s on premise data mart as required by systems migration to avoid disruptions.
  • Responsible for investigating root cause of any latency, enhancements and failure across any SQL Server, SSIS and SSRS, application performance issues and proposing or implementing enhancements or fixes as needed or forwarding them to vendors as appropriate.
  • Replaced existing problematic native database maintenance solutions with very reliable maintenance scripts for backing up databases, logs, and re-organize/rebuild indexes and update statistics across all SQL Servers.
  • Successfully migrated all company data from legacy systems to Aptos, a SaaS based Retail Management Solutions, and completed necessary post migration integration tasks to streamline and ensure uninterrupted business processes including vendor support.
  • Supported company’s system migration by preparing, cleaning up and transforming massive amount of current and historical data for loading into new system. Automated large data loading exercise from existing vendors into the new system.
  • Responsible for installing, configuring and standardizing all available versions of SQL Server database engine, SSIS and SSRS as needed on Windows servers and for maintenance and support.
  • Standardized all SQL Servers across the board to adhere to best practices recommendations regarding implementations, configurations, scripting and naming conventions of database objects.
  • Responsible for Production deployments and changes including all upgrades and patching.
  • Responsible for backing up/restoring/refreshing and creating databases ad hoc as well as supporting database/application on QA and Dev servers.
  • Responsible for creating and removing new indexes per need, query tunings, identifying long running queries and/or queries that affect application performance and taking necessary steps to remedy them.
  • Resolved excessive database deadlock issue from user RF-Guns on Production WMS SQL Server by reducing deadlocks up to 96%.
  • Responsible for automating EDI interfaces between different vendors and capturing incoming and outgoing data to/from SQL databases
  • Responsible for granting/revoking user access permissions/requests and securing SQL Server databases, schemas and SSRS servers.
  • Responsible for Retail Distribution Center with Supply Chain Management (High Jump) software application support and database support and problem resolutions.
  • Automated and supervised Accounting and Finance department’s daily data mart feed and tasks. Trained them on SQL and data error intervention steps.
  • Helped company in reducing costs and maintenance overheads by consolidating server systems and database server foot-prints wherever possible.
  • Created detailed documentation of company’s SQL Servers and dependent processes.
  • Code maintenance/project tracking through SVN, JIRA/Atlassian, GitHub and SharePoint. 24x7 dedicated support.
  • Received annual Certificate of Recognition for excellent performance 2 years in a row from company.

Confidential, Woodland Hills, CA

Senior SQL Server DBA and Developer

Responsibilities:

  • Responsible for installing and configuring SQL Server 2008, 2008R2 and 2012 on Windows server 2008/2008R 2/2012/2014.
  • Responsible for installing, configuring, and maintaining AlwaysOn Availability Groups and Failover clusters.
  • Responsible for backing up or restoring and creating databases as needed.
  • Responsible for configuring and maintaining Transactional and Merge replication in production environments.
  • Worked on very complex call center Stored Procedure scripts that automate tracking agents’ performances that served as backend to homegrown web apps.
  • Replaced nested cursors from existing Stored Procedure scripts with set based iteration, indexing and made other enhancements to reduce run time (from 7 hours to 9 minutes).
  • Created SQL Server security audit scripts that automatically audit SQL Servers and Active Directory to determine orphaned Windows logins and emails the details to DBAs.
  • Used index usage statistics for the indices on databases and removed any large indexes that were not being used sufficiently to warrant their size to save disk space.
  • Setup and maintained Log Shipping on multiple servers as needed. Researched possibilities of other SQL Server HA/DR technologies to augment companies existing setup.
  • Responsible for Production deployments and changes including all upgrades and patching.
  • Capacity planning (disk space, I/O, CPU, memory, etc.) to ensure growth. Resolve resource contention issue.
  • Researched and implemented a way to block access of users to the sensitive live production database and redirected them to synchronized copy of the prod database which saved the company from costly alternatives.
  • Tracking app performance trends, troubleshooting job failures and performance issues.
  • Deadlock troubleshooting of heavily used tables using deadlock graphs.
  • Accidental lost data\record restoration on production databases with available tools.
  • Designing and implementing backup and restoration strategies for databases as needed and troubleshooting related issues. Refreshing of Dev/QA databases automatically or on Ad-hoc requests.
  • Work with other developers and QA personnel to resolve their issues. Work with other IT teams to review codes and resolve their issues and respond to support requests.
  • Managing, granting/revoking granular SQL Server users access permissions/requests. SSRS server maintenance.
  • Created detailed documentation on company’s local and geographically dispersed SQL Servers
  • Worked with SSIS developed modified tasks that mostly included loading data from text and Excel, data flows between tables and data conversion as needed, execute SQL tasks etc.
  • SQL Server versions ranged from 2005 to 2014 and Windows versions ranged from 2003 to 2012.
  • Code maintenance through TortoiseSVN. 24x7 dedicated support.

Confidential, Santa Monica, CA

SQL Server DBA

Responsibilities:

  • Installed, configured, and maintained AlwaysOn Availability Groups and Failover clusters.
  • Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
  • Responsible for installing and configuring MS SQL Server 2005, 2008, 2008R2 and 2012 on Windows 2003, 2008, 2008R2 and 2012 and applying service packs and security fixes on these MS SQL Servers.
  • Responsible for disaster recovery and high availability solutions and database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
  • Created and migrated partially contained databases within AlwaysOn Availability Groups.
  • Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
  • Resolved post-migration dependency issues of databases using SSIS packages.
  • Monitoring the health and performance of SQL OS, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon, SQL Server Utility and other third party tools.
  • Tested newly built servers for performance impact with DB load simulators.
  • Setup and maintain Log Shipping between various locations.
  • Create necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indices to meet project requirements.
  • Identify long running scripts and update/modify with optimized coding to make them run faster.
  • Operate and oversee database and log backups and restoration, planning backup strategies, and scheduling.
  • Tables/Records restoration when necessary. Master & system database restoration when necessary.
  • Optimizing Indices, adding/deleting them when necessary for better performance.
  • Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
  • Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
  • Involved in improving database performance using Extended Events, SQL Profiler, Trace Flags, Execution plan and DTA and third party tools.
  • Worked with installation, configuration and creation of SSRS.
  • Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Confidential, Denver, CO

SQL server DBA

Responsibilities:

  • Responsible for Installing and configuring SQL Server 2008, 2008R2 and 2012 on Windows server 2008/2008R2/2012.
  • Setup and configured and supervised SQL failover cluster with shared disk for redundancy of critical SQL instances.
  • Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security, built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
  • Created various departmental reports on SSRS servers based on company needs and requests from data warehouse.
  • Responsible for Production deployments and changes including all upgrades and patching.
  • Monitored SQL Server performances including data warehouse, and tuned them as necessary for faster performance.
  • Provided 24x7 dedicated support to hundred and twenty Production, development and clustered servers.
  • Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.
  • Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indices to meet project requirements.
  • Identified long running/troublesome scripts and update/modify with optimized coding to make them run faster.
  • Responsible for automating EDI interfaces between different vendors and capturing incoming and outgoing data to/from SQL databases
  • Frequently used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
  • Developed the metrics and trending processes for SQL database sizing and growth.
  • Daily monitoring of two-node active-passive SQL cluster in a host environment.
  • Applied service packs and security fixes for all SQL Servers, and provided database administration support.
  • Participated in upgrading from SQL Server 2005 to SQL Server 2008 and from SQL Server 2008 to SQL Server 2008R2 and 2012.
  • Used Policy based Management to secure facets of various instance and database targets.
  • Tested newly built servers for performance impact with DB load simulators before moving to production.
  • Automated common operations and tasks, created critical production alerts and design practices for portability using DACPAC.
  • Experience in consolidating packages and the parameters for projects using ISPAC.
  • Performed database backups and migrations for production, test and development environments.
  • Worked with SQL DBA team and SQL Developers to help optimize, performance tune, create indices and optimization of slow running queries and locks using scripts and Database Tuning Advisor (DTA).

We'd love your feedback!