Postgresql Dba Resume
3.00/5 (Submit Your Rating)
SUMMARY:
- Deeply and broadly experienced security, software, network and database engineer with team lead experience.
- Conversant with 15+ different programming languages; expert in Python, Ruby, C, C++, Bash
- Systems administrator for various Unix systems (Linux, Solaris, HP/UX), plus Windows and Mac
- Database design and admin with Postgresql, MySQL, misc NoSQL databases
- Web development, recently with Python/Django and misc. JavaScript frameworks
EXPERIENCE:
Confidential
PostgreSQL DBA
Responsibilities:
- Automated an AWS ECR deployment using Docker, Python and PowerShell
- Wrote an ETL tool in Python/SQLAlchemy to adapt an old PostgreSQL schema to a new one
- Used Cmake and AWS Code Pipeline to work on a deployment/build system
Confidential
Cloud engineer
Responsibilities:
- Did Python programming and PostgreSQL work getting Pgloader to download updates from S3 and install them.
- I wrote 75% of the Python code for the first project I did for this company, to drive Terraform to install AWS infrastructure
- I used Jenkins and Chef on a separate project.
Confidential
Sr. Solutions EngineerResponsibilities:
- Devops with Ansible, Ruby/Rails, Python Django, Git, Jenkins; Designed a microservice architecture for one layer of a web application
- A PL/1 to Java translator project (I was drafted when the manager found out I had compiler experience) … got a working parser / AST going for the subset of PL/1 we had to convert in about 3 weeks. Used Python, Java, ANTLR4, PLY, PLYplus.
- Test automation with an offshore team using a keyword - driven approach (Robot Framework)
Confidential, Seattle
Sr. Solutions EngineerResponsibilities:
- refactoring a large Python codebase into Confidential . format rehosting Jenkins and Trac servers on AWS and adding SSL to each evaluating SaltStack working with Amazon Redshift and Amazon RDS (both based on PostgreSQL) setting up tests for PySpark
- Using AWS Confidential with a Python script to terminate idle AWS instances
Confidential
Sr. Solutions EngineerResponsibilities:
- Python script for rebranding ( Confidential became Confidential ) much work with Git branching and merging
- Ruby code: Chef cookbooks and recipes.
Confidential
Sr. Solutions EngineerResponsibilities:
- Working for their client, a Southern CA electronics firm speed up and otherwise enhance a Python (SCons) based build system
- Sped up one section 75% the first week of this contract
- Recommended future tools and strategy for their build infrastructure
Confidential
Contract developer
Responsibilities:
- Python/Pyramid work to update an internal web interface that wasn't working correctly
- Used Backbone.js, Bootstrap.js, Handlebars.js on this interface
- Main problem was that timing of updates to Redis were out of sync with writes to a PostgreSQL database; I figured this out and made the web interface not just show a blank screen but say “wait 5 seconds”
- Used Ansible for deployment to their internal stacks wrote a script to load data into Amazon Redshift
Confidential
Contract developer
Responsibilities:
- Used Python to learn the API for controlling their data storage appliance
- Developed and maintained a Python/Django (with CSS & JavaScript) application as an alternative to the UI on one of their data store systems.
Confidential
DevOp DBA
Responsibilities:
- cloud-based API provisioning
- Worked with Openstack. scripting using it Nova and Neutron control languages
- Bootstrapped myself into Chef when the existing Chef guy wasn't getting it done.
- Worked briefly with Puppet
- Used Python for various tasks
- Used EnterpriseDB, which is based on PostgreSQL
- Worked with noSQL database Cassandra administered MySQL.
Confidential
DevOp
Responsibilities:
- Environment consists of Ruby/Rails, MySQL, Redis
- I wroteRuby alerter code, mostly, using the Pony email-sending Gem.
- Also worked with Amazon EC2 and RDS.
Confidential, Bainbridge Island, WA
Sr. Solutions EngineerResponsibilities:
- Wrote Python code and unit tests for their tax compliance software engine.
- Worked with Amazon EC2, DynamoDB and S3.
Confidential, Seattle, WA
Contract administrator
Responsibilities:
- MongoDB and Cassandra.
- Wrote software tools and scripts in shell and Python.
- Did 3 rd -tier support and troubleshooting for Cassandra and MongoDB.
Confidential, Kirkland, WA
Sr. Solutions EngineerResponsibilities:
- Wrote 1300 lines of working Python in 2.5 months in support of a bioinformatics application for their client.
- Also worked with Google App Engine, Amazon AWS, and Django.
Confidential, Bellevue, WA
Sr. Solutions EngineerResponsibilities:
- Did Python and Java programming using tools web.py for a REST implementation
- Used SqlAlchemy’s SqlSoup for database reporting code.
- Investigated noSQL databases.
- Also helped troubleshoot a MySQL round-robin replication problem and did other MySQL DBA work.
Confidential, Seattle, WA
Sr. Solutions Engineer
Responsibilities:
- I did web, database (mostly Postgresql) and programming support of customers.
- Wrote middleware and data manipulation software in Python, Perl and C.
- See projects below for more detail on this.