We provide IT Staff Augmentation Services!

Database Intern Resume

San Diego, CA

SUMMARY

  • Database Administrator with 4+ years of core IT experience in Database Installation, Designing, Administration and Troubleshooting database servers like MySQL 5.7,5.6,5.5, 5.1, on Windows, Linux, Solaris and Unix platforms.
  • Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade, migration.
  • Experience in Infrastructure Development and Operations involving AWS Cloud platforms, EC2, EBS, S3, VPC, RDS, SES, ELB, Auto - Scaling, CloudFront, CloudFormation, ElacticCache, CloudWatch, SNS, AWS Import / Export.
  • Worked on Micro Services architecture in AWS by creating ELB’S, Auto-Scaling groups in EC2 using prebaked AMI and Docker containers.
  • Installed and configured an automated tool Puppet that included installation and configuration of Puppet master, agent nodes and an admin control workstation.
  • Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
  • Maintained database security by Granting/Revoking users/role authorizations and privileges.
  • Expertise in online transaction processing (OLTP) and online analytical processing (OLAP) on multi-user systems involving large databases for Financial, Telecom, Media, Retail and Insurance clients.
  • Strong MySQL and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment.
  • Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
  • Involved in client Production Support and Maintenance - Tasks including programming, debugging and testing of existing applications that run in a production environment for purposes of remediation system errors or to extend application life span.
  • Usage of MySQL storage engines like MyISAM and InnoDB as per the data classification. Expertise in database migration from MYISAM format to INNODB storage engine to increase performance and betterment of integrity constraints.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, UNIX, Centos.

Languages: SQL, Perl, Shell Scripting, Visual Basic.Net

Databases: MySQL, MSSQL, NoSQL and PostgreSQL

MS Office Tools: MS-Word, MS-Excel, Power Point, MS Access, VISIO, MS-Publisher, MS-Outlook.

Communication &Networking: FTP, SFTP, SCP, SSH, Putty, NFS/CIFS.

ETL Tools: JasperETL, CloverETL, Pentaho’s Data Integration, Talend.

Web Technologies: HTML, CSS, XML, XHTML, JavaScript, Bootstrap, PHP

Methodology: Agile, Agile SCRUM, Waterfall, Test-Driven Development.

Reporting Tools: Crystal Reports, SSRS, QlikView, Microsoft Clustering Services (MSCS), Dashboards.

Amazon Web Services (AWS): EC2, Lambda, Elastic BeanStalk, Elastic load balancer and Auto-Scaling, S3, RDS, DynamoDB, VPC, Route53, CloudFront, CloudWatch, CloudFormation, OpsWorks, KMS, IAM, SQS, SNS

DevOps Tools: Consul, Jenkins, Docker, Ansible, Puppet, Chef, Git, Nagios, Monit.

Server: Apache, Tomcat

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Database Intern

Responsibilities:

  • Launching Amazon EC2 Cloud Instances using Amazon Web Services (Linux/ Ubuntu) and Configuring launched instances with respect to specific applications.
  • Implemented a Continuous Delivery pipeline with Docker, Jenkins and GitHub and AWS AMI's, whenever a new GitHub branch gets started, Jenkins, our Continuous Integration server, automatically attempts to build a new Docker container from it, The Docker container leverages Linux containers and has the AMI baked in. Converted our staging and Production environment from a handful AMI's to a single bare metal host running Docker.
  • Installed and configured MySQL on Linux and Windows environments.
  • Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity .
  • Increased database performance by utilizing MySQL configuration changes, multiple instances and by upgrading hardware.
  • Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
  • Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
  • Troubleshoot all Replication Issues including Application user connection. Provide schema alterations for MySQL databases and software
  • Provide Database User account administration, connection assistance, and assist with configuration of connecting applications.

Confidential, Michigan, MI

Graduate Assistant

Responsibilities:

  • Experience in Infrastructure Development and Operations involving AWS Cloud platforms, EC2, EBS, S3, VPC, RDS, SES, ELB, Auto-Scaling, CloudFront, CloudFormation, ElacticCache, CloudWatch, SNS, AWS Import / Export.
  • Implementing an open source audit login for MySQL databases, all the logs can be viewed in real-time from the department web app.
  • Expertise in planning and implementing MySQL Server security, database permissions, Backup/Recovery, Client/Server Connectivity and running Database Consistency Checks.
  • Developed template for collection of metadata to streamline and optimize the process for data loading and Monitoring Alert logs for any errors, problems or processes running.
  • Deep expertise in building and breaking cloud-scale systems, with focus on Information Security, User Authentication, Network Security, Key Management, Resource Isolation.
  • Highly organized, able to multi-task, the ability to work individually, within a team, and with other groups.
  • Lead discussion sections, tutorials, or laboratory sections. Assisted faculty members or staff with student conferences.
  • Evaluated and graded examinations, assignments, or papers and recorded grades and Notified instructors of errors or problems with assignments.

Confidential

MySQL Database Administrator

Responsibilities:

  • Experience in Database Installation, Designing, Administration and troubleshooting database servers like MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1 on Windows, Linux and Unix platforms.
  • Good Knowledge of MYSQL Server Clustering, Replication (c), and Conduct a walkthrough of database design including the entire architecture, physical logical schema, selection of storage engines InnoDB, MyISAM, NDBCLUSTER, coding of stored procedures triggers prior to deploying solution.
  • Design and create databases, schemas, tablespaces, tables, stored procedures, triggers and more, by using DML, DDL, DRL, TCL and DCL SQL syntaxes on MySQL DBMS.
  • Experience in Database Backup, developed backup and recovery scripts using UNIX shell, performed database Tuning - Set initialization parameters, optimized file I/O, and tuned the physical model by optimizing and reorganizing the schema.
  • Demonstrate expertise in utilizing load data in file tool, MYSQL dump, MYSQL hotcopy, MYSQL import for data migration, Data Transformation Services DTS, and Data Stage in RDBM systems in MYSQL Servers.
  • Worked on all phases of database development lifecycle, from gathering requirements to testing, implementation, and support. performance issues by configuring thread pooling at MySQL level.
  • Also bench-marked various types of AWS instances with differing configurations.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
  • Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
  • Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master.

Hire Now