We provide IT Staff Augmentation Services!

Senior Database Engineer Resume

OBJECTIVE:

A responsible and challenging position in the field of Databases, which utilizes the technical and functional skills acquired over 7+ years of database experience

SUMMARY:

  • Currently working as Senior Database Engineer at Confidential .
  • Client National Oceanic and Atmospheric Administration from .
  • PostgreSQL database administrator at Confidential
  • IT Professional with 7+ years of total IT experience as PostgreSQL Database Administrator.
  • DBA for PostgreSQL 8.x/9.x,10 and PostgresPlus Advanced Server 8.x/9.x,10 and community flavor
  • Experience performing replication and setting up Disaster Recovery for Postgres and Mongodb
  • Installing, configuring and tuning Mongodb PostgreSQL, MySQL and MS sql databases
  • Experienced in Installation, Upgrade, Migration from MySQL, SQL Server, Oracle to Postgres.
  • Experienced on tools like Postgres Enterprise Manager, Replication Studio, xDB MMR, Pgpool, Migration Toolkit (MTK), Pgbouncer, BDR etc.
  • Experience leveraging Postgres on RDS AWS and google Public cloud
  • Implemented various PostgreSQL tools for High Availability, like Streaming Replication, MMR
  • Experience in PostgreSQL Architectural Health Check - up, fine tuning on various platforms .
  • Experience with performance tuning.
  • Experience on DevOps tools like puppet, salt,
  • Experience in Oracle 10g/11g/12c database installation, configuration, administration, tuning and troubleshooting, Migration & Upgrading of Databases.
  • Multiple OS experience.
  • Excellent communication skills with ability to work independently as well as collaboratively in team environment to contribute problem-solving strategies. At ease in interacting with people at all levels, able to work under pressure.

TECHNICAL EXPERTISE:

Database: PostgreSQL & EnterpriseDB PPAS 9.x,10, Oracle 11.2, 12c

Operating Systems: Solaris, Red-Hat, Suse, AIX, HP-UX and Windows.

Languages: Shell Script,

Other Tools: Slony, PgBadger, Putty, Remedy, EDB xDB MMR, EDB EFM, BART, BDR,

DevOps: Docker, Salt, Puppet,

PROJECT EXPERIENCE:

Senior Database Engineer

Confidential

Responsibilities:

  • Design, setup and Administer high volume and High transaction (failover + offsite) PostgreSQL DB installations with Streaming and MMR replication.
  • Implement a database roadmap to ensure long-term data scalability and execution viability.
  • Create and maintain implementation strategy for high load systems.
  • Ensure uptime of high transaction per second (TPS) database instance during financial market hours.
  • Maintain backup, archival, and synchronization strategy and scripts on multi node, replicated cluster.
  • Initiate standard operating procedure (SOP) guidelines.
  • Create and maintain documentation and emergency checklist disaster recovery dashboard for DBA coverage and direction of system evolution.
  • Standardize software and server configuration process to facilitate automated cluster node deployment and maintenance. Evaluate, install upgrade and configure database software and database related application packages.
  • Maintain and manage PostgreSQL Replication clustering environment and SQL Server clustered environments
  • Review and validate logical database designs and create and implement physical designs.
  • Proactive database maintenance activities (indexing, rebuilding indexes, table partition, monitor) in PostgreSQL and SQL Server.
  • Troubleshoot PostgreSQL and Server outages as they occur, including after-hours and weekends.
  • Configure and monitoring utilities to minimize false alarms.
  • Tuning SQL queries to improve performance in both SQL Server and PostgreSQL Databases. writing queries, developing stored procedures, creating views, developing functions, and creating other database
  • Provide 24 x7 on-call troubleshooting and problem resolution.
  • Managed and support the deployment and integration of enterprise databases
  • Provide performance tuning and monitoring SQL Server and PostgreSQL database.
  • Monitor and optimized the security permissions for all enterprise data servers.
  • Deploy and administer scripts to optimize database health, locks, Deadlocks, resource latches objects,
  • Assess needs and apply database software patches and updates without schedules downtime
  • Monitor, support, configure and physically build systems; support other engineering team members as needed in their work.
  • Involves in code automation using Jenkins, puppet and GitHub .
  • Performs full life-cycle development, from initial requirements gathering through development and maintenance on short-cycle iterative projects.
  • Developed and maintaining data warehouses using Erwin data modeling tools for conceptual logical and physical data models and loading data in Amazon Web Service redshift.
  • Build database schemas, tables, views, and stored procedures on PostgreSQL and oracles respectively (loading data from spreadsheet, loading data from flat files, Randomly sampling data, identifying and removing duplicates and preventing duplicate rows
  • Implement policies (configuration standards) and procedures for the database environment. .
  • Provided Database Administration, management and support of SQL systems such as PostgreSQL, SQL, Server Oracle and NoSQL Systems such as MongoDB.

Senior DBA

Confidential

Responsibilities:

  • Administer several doubly-redundant (failover + offsite) Postgresql installations with Streaming and MMR replication.
  • Ensure uptime of 1000+ transaction per second (TPS) database instance during financial market hours.
  • Maintain backup, archival, and synchronization strategy and scripts on multi node, replicated cluster.
  • Revise data replication and partitioning for archival and disaster recovery.
  • Initiate standard operating procedure (SOP) guidelines.
  • Test and recommend hardware upgrades for cross-environment server migrations, including FusionIO ioDrives to handle market open IOPS demands.
  • Create and maintain documentation and emergency checklist disaster recovery dashboard for DBA coverage and direction of system evolution.
  • Standardize software and server configuration process to facilitate automated cluster node deployment and maintenance.
  • Hold classes for developers on advanced query techniques and avoidance of common pitfalls.
  • Implement a database roadmap to ensure long-term data scalability and execution viability.

Senior PostgreSQL engineer

Confidential

Responsibilities:

  • DBA for two continuous development and integration projects managed by an Agile Scrum Master. Responsibilities are assisting The Application Development team with schema and object configuration and automating script in the CI/CD environment, manage databases, in many cross platform environments.
  • Migrating databases from on premise to cloud using flyway database migration.
  • Designing databases, schema and schema objects for on premise as well as RDS in AWS.
  • Use GIT and TFS to manage tickets in our environment
  • Creating indexes (spatial, JSON and XML ), partition table, materialize views to facilitate performance
  • General XML log file with a histogram on PGbadger for monitoring dataset logs and deadlocks.
  • Generating XML files for table definitions and data. Use Table to XML and Schema to XMLSchema for table and schema XML dump formats.
  • Using Postgres FDW (Installing the extension, creating a server object, creating user mapping, creating the foreign table) for external data movement and utilization.
  • Create functions utilizing Java Script Notation replacing XML function to perform DDL and DML database transaction queries.
  • Creating indexes( JSON index, Hstore, Btrees, bitmap and more) for query enhancement and sort requirements
  • Create XML to dump XML format data and Table to XMLSchema functions.
  • Install and configure new PostgreSQL and oracle servers.
  • Migrate from Oracle database to PostgreSQL using ORA.PG and foreign data wrapped, AWS Database Migration Service and Schema conversion tool.
  • Set-up and maintain replication PostgreSQL
  • Managing the databases and their servers on premise and on Cloud
  • Configure and maintain configuration files, manage connections and setting user securities by authentication, roles, user group and creating databases .
  • Upgrading extension and bug fix.
  • Schema design, Creating tables, constraints store procedure and trigger and indexes
  • Importing and exporting data in and out of PostgreSQL. Working with foreign table expression and foreign data wrapped
  • Administer access control and auditing (Create users, roles, group and assign privileges to access the data store).
  • Configuring PG pool II for connection pool(use for manage multiple concurrent connections and Load balancing )
  • Performing PITR, backup archiving the WAL and taking base backup.
  • Manage Backups and routine recovery testing to ensure adherence to stated Recovery Time Objectives and Recovery Time Objective
  • Automating and scaling PostgreSQL and Oracle on premise and on cloud (AWS).
  • Designing and deploying Relational databases (PostgreSQL and Oracle) to RDS in Amazon web service
  • Spin up EC2 instances on Amazon and use both PostgreSQL and oracles as infrastructures as a service on Amazon cloud
  • Managed EC2 in stances, S3 and glacier storages and RDS on Amazon web service.

SQL Server and Oracle DBA

Confidential, Baltimore, MD

Responsibilities:

  • Documented the infrastructure of existing and new databases.
  • Performs full life-cycle development, from initial requirements gathering through development and maintenance on short-cycle iterative projects.
  • Install, Configure, and Manage SQL Server 2005, 2008 R2, 2012, 2014, in Dev, Prod and Test environments
  • Apply Service Packs/Hot Fixes on SQL Server
  • Upgrade from SQL Server 2008R2 to SQL Server 2012 and 2014
  • Experience in Disaster recovery through backup/restore, point-in-time recovery
  • Refresh Database as needed
  • Configure and maintain HA options (Log shipping, mirroring, replication, clustering, Always On)
  • Schedule jobs and create alerts as needed
  • Create Server logins, database users, and implement Transparent Database Encryption (TDE)
  • Configure Tempdb for better performance
  • Configure Table Partitions to improve I/O access and performance
  • Data compression and Shrink database as needed
  • Monitor (Memory, CPU, Disk Utilization, I/O, Blocks, Deadlocks, Fragmentation, Long running query) to optimize database performance
  • Rebuild, reorganize Index and update statistics at regular intervals
  • Use DBCC and DMV to check database condition and consistency
  • Experience in creating and modifying Indexes (Cluster/Non-Cluster), Constraints (Unique/Check) and Views
  • Assist Database Developers to Optimize SQL queries and Stores Procedures.
  • Write Ad hoc Transact-SQL scripts for reporting and maintenance
  • Create Ad hoc package, configure different level of security and deploy package using SSIS
  • Resolve issues reported by customers Administrate SharePoint
  • Environment: Microsoft Windows Cluster Server, Windows Server, XML, SQL Server
  • Developed and maintaining data warehouses using Erwin data modelling tools for conceptual logical and physical data models and loading data in Amazon Web Service redshift.
  • Build database schemas, tables, views, and stored procedures on PostgreSQL and oracles respectively (loading data from spreadsheet, loading data from flat files, Randomly sampling data, identifying and removing duplicates and preventing duplicate rows
  • Documented backup, restore and recovery procedures for existing databases.
  • Interfaced with end-users to collect, document and help troubleshoot database-related issues they faced such as slow response-times, inability to connect to a database etc.
  • Used Oracle Expert for monitoring and gathering tuning recommendations of existing databases.
  • Installed and configured Oracle 10G, 11 Enterprise Edition, Oracle Enterprise Manager with Oracle Diagnostics & Tuning Packs
  • Set up, configuration and troubleshooting of SQL *Net and Net8 on servers and client machines.
  • Data Migration using Export, Import, and SQL Loader utilities.
  • Provided first-level database support to end-users.
  • Provide weekly status reports of work accomplished and work in-progress.
  • Drafted a backup and recovery document for a customer's database that included the backup schedule and testing results of various database failures and the database recovery using existing backup methods.
  • Interface with end-users to collect, document and help troubleshoot database-related Issues, such as, slow response-times and the inability to connect to a database.

Hire Now