We provide IT Staff Augmentation Services!

Pgsql/aws/sql Server Dba Resume

Plano, TX

SUMMARY:

  • Total of 7+ years of IT experience and extensive experience in PostgreSQL/AWS/MS - SQL 2016/ 2014/2012/2008 R2/2008/2005 server administration including design and implementations of distributed / Replicated Database, Planning/ Implementing backup/ Recovery Strategies and performance tuning, Design and develop using EWRIN.
  • Hands on experience in design, implementation of PostgreSQL instances on AWS.
  • Worked with teh development team to create appropriate cloud solutions for client needs.
  • Reported all issues.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database ConsistencyChecks using DBCC Utilities.
  • Solid Experience in Migrating database from coin servers to AWS RDS and Ec2.
  • Worked extensively on MS SQL Server 2000, 2005 & 2008 R2
  • Experience working with Production 24/7 and Development Environments.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in high availability/contingency solutions - Replication, Log shipping & mirroring.
  • Hands on experience in Troubleshooting database issues.
  • Implemented High Availability in SQL 2012/2016 by configuring Always on Availability groups acrossWindows Server Failover Clustering using Failover Clustering Instances.
  • Implementation experience of Microsoft Clustering Services for High Availability of Servers.
  • Proficient with SQL Management Studio, scheduling jobs with SQL Server Agent, SQL Profiler, restoringdatabase using full, differential, and log backups.
  • Automated teh cloud deployments using Chef and AWS cloud formation templates.
  • High level of exposure to SQL performance tuning query optimization using Database Engine TuningAdvisor (DTA) and SQL Server Profiler7.
  • Experience in installation, configuration of SSIS and SSRS in 2005 and 2008.
  • Exposure to SSIS Architecture and designing end to end DTS & ETL process.
  • Good skills in client server architecture, design, system requirement study, and project management.
  • Experience in using OLTP and OLAP Technology.
  • Working Experience with Puppet, Ansible, Chef, AWS (OPS Work) and OpenStack.
  • Experience in database development, for creating complex database queries, Indexes, Views, StoredProcedures and Triggers in SQL Server.
  • Knowledge about Microsoft Azure in creating cloud environment and managing teh application servers across Microsoft managed global data cent.
  • Designed and implemented fully automated server build management, monitoring and deployment by utilizing Puppet.
  • Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding andReorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
  • OLAP experience like Data Analysis Services, Business Intelligence tools.
  • DB maintenance, creation of users, configuring permissions and assigning roles to users.
  • Excellent analytical, problem solving, communication and interpersonal skills
  • Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing RootCause Analysis (RCA) for troubleshooting and resolving teh issues.
  • Strong MYSQL Skills and Good knowledge and experience working on Apache Server and IIS.
  • Strong analytical and conceptual skills, rapid grasper of new technologies and business terminology.
  • Worked on Sizes 6Tb DB
  • Worked on Very Busy Application with Users Range .
  • Experienced with building deploying and troubleshooting web services

TECHNICAL SKILLS:

Databases & Services: SQL Server 2000/2005/2008 R2,2012 and 2014,2016, ORACLE, MYSQL,MS-ACCESS, SSIS, Reporting Services, AWS cloud, Business Intelligence, Database Tuning Advisor, T-SQL, MSDE, OLAP, SQL Plus 8.0, PL/SQL 8.0, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs, MYSQL, ODBC, JDBC, Ansible, Chef, Puppet, Docker.

Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services

Programming/Scripting: Script, XML, HTML, DHTML, T-SQL Programming, VB 6, C++, JAVA.

Operating Systems: Windows XP/NT/2000/98, Visa, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.

Protocols: TCP/IP, HTTP, FTP, SSH, TELNET

Tools: Version one, Jira, HPSM, Regates, Idera.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

PGSql/AWS/Sql server DBA

Responsibilities:

  • Installing, Configuring and Maintenance of MS SQL 2005 & 2008 R2 2012 and 2014,2016 Server.
  • Maintain databases using teh following database tools as necessary: Toad, SQL Developer, SQL Plus, SQLServer Management Studio, PG Admin, PG Backup, psql.
  • Supporting for production, QA and development Oracle, PostgreSQL, MySQL and MSSQL databases for over25 servers, including over 40 database environments.
  • Migration of Oracle and PostgreSQL database structures from dev and QA environments into productionEnvironments.
  • Prepared automation scripts and developed PostgreSQL database architecture.
  • Involved in teh migration of databases from SQL server 2012 to SQL server 2016Designed, developed andmaintained PostgreSQL database architecture.
  • Solid experience with and understanding of AWS
  • Administration of PostgreSQL, MySQL and MSSQL databases which support in-house application codeincluding capacity and performance tuning as well as off-hours deployments of new application releases.
  • Involved in tuning teh database and server performance.
  • Configured and maintain Log shipping,
  • Monitored user access and PostgreSQL database security
  • Create scripts to monitor all teh pluggable databases.
  • Creating and managing Partitioning and File Groups.
  • Hands on experience on performance tuning tools such as IDERA.
  • Implemented several SSIS (SQL Server Integration Services) packages for data feed from various servers andenvironments. Deployed teh packages using deployment utilities.
  • Implemented Disasters Recovery plans to reduce teh downtime of teh SQL Server using Log shipping andmirroring and Replication models.
  • Created reports using SSRS in SQL server 2008 in various occasions and deployed for user’s access
  • Working closely with application developers to participation on designing of tables, developing making teh DataDictionaries, and writing of views, complex Stored Procedures, UDFs, Trigger, and Indexes according to their requirements. Written Triggers to store teh data for Audit maintenance
  • Running of DBCC command for checking database consistency as part of SQL Maintenance plans.
  • Working closely with application developers to participation on designing of tables and writing of views, complexSPs, UDFs, Trigger, and Indexes according to their requirements.
  • Involved in Stored Procedures Tuning and Performance and Query Tuning Activities
  • Using SQL Profiler and Tuning Queries to improve performance and used Index Tuning Wizard.
  • Used BCP Command line tools to Import/export teh table data into Flat Files and Flat files to tables.
  • Deploying DTS & SSIS packages & Setup teh non-SA jobs.
  • Worked in OLTP & OLAP environment in several projects which includes QA, PROD & DEV database in SQLServer
  • Hands-on experience with configuration and automation tools such as Puppet and Chef.
  • Monitoring Server Performance and Activities. Tuning Queries, created necessary indexes.
  • Auditing teh Security checks on QA\PRD servers as per application security standards
  • Involved in creating Backup & Restore strategies.
  • Implemented Disasters Recovery (DR) plans to reduce teh downtime of teh SQL Server
  • Resolving of High CPU spikes by identify long running Queries, Blocking & Deadlocks
  • Transferred data (ETL) to Data ware house Environment using SSIS.Dropped and recreated teh indexes on tables for performance improvements. Used Index tuning wizard for Tuningf indexes.Scheduled teh backups for Databases and Transaction log. Performed restoration operations. Suggested Backupstrategies.
  • Worked as an integral part of teh development team with troubleshooting development and maintenance ofsystems.
  • Worked with teh development team to create appropriate cloud solutions for client needs.
  • Reported all issues.
  • Worked in Agile Environment.
  • Designed, developed and migrated existing SQL databases.
  • Automated DBA activities and upgraded existing databases.
  • Generated database reports such as financial data statements and user data.
  • Administered and executed complex databases for critical problems.
  • Prepared and updated scripts for various administrative tasks.
  • Maintained documentation of scripts in all source repositories.
  • Developed scripts for database monitoring and tuning procedures.
  • Conducted Linux administration activities and managed test databases.
  • Evaluated database performance and executed table maintenance processes.
  • Migration and/or managing a large database (1 TB or larger)
  • AWS and clustering
  • Migrating SQL Server and PostgreSQL up in teh cloud

Environment: MS SQL Server 2005, 2008 R2,2012,2014,2016 AWS Cloud, PostgreSQL, MS SQL ServerIntegrated Services (SSIS) SQL Agent, MS Access, .NET Framework, OLAP & OLTP Excel, Chef, Visual Studio, Windows 2008/2003 server SSMS, SSIS, IIS.

Confidential, Richmond, VA

PGSql/AWS/Sql server DBA

Responsibilities:

  • Installation, development, maintenance and enhancement of physical PostgreSQL RDBMS to support teh Agiledevelopment teams.
  • Developing and maintaining OLTP, data warehouses and operational data stores and utilize ERwin datamodeling tools for logical and physical data models.
  • Created and maintained various databases for Production, Development and Testing environments using MS SQL Server 2014, 2012, 2008r2, 2008, 2005.
  • SQL scripts for Conversion Reports, Data Analysis and Data Corrections.
  • Installation, maintenance and administration of Oracle, DB2 or another RDBMS.
  • Patching all teh SQL Servers 2008, 2008R2, 2012, 2014 with teh latest service packs.
  • Developing databases with an Agile development process and ceremonies including scrums, planning events,backlog grooming, retrospectives and demos.
  • Involved in migration of SQL 2012 TO SQL 2014.
  • Experience with SQL, PostgreSQL, TOAD 9.5, Omegamon.
  • Data Conversion Strategies on various databases (PostgreSQL, Oracle, DB2)
  • Database partitioning Strategies on various databases (PostgreSQL, Oracle, DB2)
  • Performance and tuning of applications on various databases (PostgreSQL, Oracle, DB2)
  • Relational and Dimensional Modeling.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports thatdraw content from a variety of data sources.
  • Experience in managing virtual instances and disks using Puppet.
  • Design and implementation of large databases and data warehouses utilizing both relational and dimensional design concepts.
  • Written Chef Cookbooks for various DB configurations to modularize and optimize product configuration.
  • Converting production support scripts to Chef Recipes and AWS server provisioning using Chef Recipes.
  • Operating System and Infrastructure experience with Linux, Windows 7, Unix, Solaris.
  • Experience in OLTP, data warehousing and operational data stores and concepts.
  • Experience in Version One Application Lifecycle Management Tools.
  • Experience in Jenkins and Continuous Integration.
  • Source code versioning with Git and Stash.
  • Environments utilizing Cloud Technologies such as Amazon Web Services.
  • Member of open source software communities.
  • Proactively monitored, determined and solved issues at SQL/database/server levels.

Environment: Windows 2003/2008,2012, MS-SQL Server 2014/2012/2008 r2/2005 AWS Cloud, PostgreSQL, Visual Studio, VMware machines, HTML, XML, MS Access, Sites Scope monitoring tool, Chef, OLAP & OLTP Excel, SSMS, SSIS, IIS

Confidential, Redmond, WA

Sr. SQL Server DBA

Responsibilities:

  • Installing, Configuring and Maintenance of MS SQL 2005 & 2008 R2, 2012 Server.
  • Routine Hourly, daily, weekly and monthly database backups and rebuilding indexes and running of updatestatistics on PROD databases.
  • As teh Senior database dba, involved in database design, implementation and performance tuning fordevelopment, QA, production, Disaster recovery environments.
  • Implemented several SSIS (SQL Server Integration Services) packages for data feed from various servers andenvironments. Deployed teh packages using deployment utilities.
  • Implemented Disasters Recovery plans to reduce teh downtime of teh SQL Server using Log shipping andmirroring and Replication models.
  • Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuningof Database Application.
  • Created reports using SSRS in SQL server 2008 in various occasions and deployed for user’s access
  • Working closely with application developers to participation on designing of tables, developing making teh DataDictionaries, and writing of views, complex Stored Procedures, UDFs, Trigger, and Indexes according to their requirements. Written Triggers to store teh data for Audit maintenance
  • Setup & Monitoring of Replication agents and troubleshooting
  • Database performance monitoring using SQL Profiler and system monitor and Tuning Queries to improveperformance and using Index Tuning Wizard.
  • Work closely with QA and application developer team for bug tracking.
  • Writing queries to generate reports for data analysis using SQL Server Reporting Services (SSRS).
  • Experience in designing and developing data analysis tools.
  • Developed Reports by using Server Project Wizard Report and Report Model Project.
  • Developed Reports with different styles using Table Sub Reports and Matrix.
  • Performing Database administration and Management activities in a safe, recoverable and professional mannerthat ensures teh optimal operation at all database environments.
  • Monitor teh database systems to ensure secure services with minimum downtime and testing and load testing.
  • MYSQL database maintenance for teh corporate website and retail website. Database integrity and security forcompany web sites and managing and controlling teh traffic over teh sites.
  • Managed teh users, computer environment by using Group Policies

Environment: Windows 2003/2008, MS-SQL Server 2012/2008r2/2005, MS Access, .NET Framework, Visual Studio, Excel, HTML, XML, SSMS, SSIS, SSRS, IIS

Hire Now