We provide IT Staff Augmentation Services!

System Administration, Mysql Dba Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • I have been working as a senior consultant sin Confidential ’s IT Professional Services practice. My experience includes server administration(Unix/Linux), setting up servers in high availability mode, web server setup/configuration and performance tuning, mail and file server setup, custom application development using
  • LAMP architecture, remote system monitoring using Nagios, setting up MySQL servers in clustered environment. I can quickly adapt to new technology and company needs allowing me to provide quality solutions.

TECHNICAL SKILLS:

Technologies: Unix/Linux, LAMP Stack, SQL Server, Heartbeat, HA Clusters, DRBD, Nagios, LAN/WAN setup, MySQL(DBA), Hadoop Administration / setup (multi - node), MongoDB

Functional Expertise: Server Administration, High Availability Server Setup, Database Setup

Industry Expertise: Managed Services, Data Storage, Health, Online retail

PROFESSIONAL EXPERIENCE:

Confidential

Setup Hadoop / Mongodb cluster

Responsibilities:

  • Setup 3-node Hadoop cluster for data analysis and reporting
  • Routine administration of Hadoop ecosystem
  • Worked with data delivery teams to setup new Hadoop users
  • Monitor Hadoop cluster connectivity and security
  • Collaborating with application teams to install operating system and Hadoop updates, patches, version upgrades when required
  • Setup Mongodb cluster
  • Routine administration of Mongodb cluster
  • Monitoring Mongodb cluster and working towards resolution of any issues

Confidential, Sunnyvale, CA

System Administration, Mysql DBA

Responsibilities:

  • Worked closely with Business to understand the requirement and provide a solution
  • Worked with clients IT team to setup virtual servers
  • Installed Tomcat on a virtual server running windows Server 2008 R2
  • Configured LDAP authentication under Tomcat for user login
  • Setup MySQL server under linux
  • User account management
  • Wrote scripts to extract data from clients SAP system and populate the local MySQL database
  • Wrote scripts to periodically update the local MySQL database with the latest changes to the SAP database

Confidential, Sunnyvale, CA

System Administration

Responsibilities:

  • As a linux administrator worked closely with Business and clients IT teams (storage, Network ops) to validate and facilitate smooth transition of all production system from one data center to another
  • Validated firewall rules, apache setups, Network setup, installation of SSL certs, SSO for smooth transition
  • Tested / validated all the legacy cgi/perl applications were running smoothly without issues after the transition of the datacenter was completed

Technologies: Linux / Unix (LAMP Stack) Web Server (Apache), CGI, Perl, Oracle WebGate

Confidential, New York

BI, System Administration

Responsibilities:

  • Setup Virtual LAMP infrastructure, (Centos, Apache, MySQL, and PHP)
  • Provided full linux / unix administration support for all the serves setup
  • Package management using yum
  • Monitored overall status and health of the servers
  • Maintained user accounts and wrote scripts to perform system backups
  • Managed web server, including CGI scripting, web-based database access
  • Wrote queries to extract data from production MS-SQL server do data conversion as per business rules and store it in the MySQL database
  • Did extensive php coding for custom survey by the Nurses for NDNQI
  • Wrote queries to generate reports as per business requirements
  • Generated XML using php and MySQL for submitting survey results to the national database of NDNQI
  • XML generation above required validation against an exhaustive list of business rules

Technologies: Virtual server setup, Web server setup, MySQL installation and DB design and setup, PHP coding, SQL queries

Confidential, Sunnyvale, CA

Infrastructure Setup / System Administration, Global Services

Responsibilities:

  • Installed / configured solaris servers
  • Administrating software Package like adding, deleting of software packages
  • Setup Web Servers for all the environments dev/test/stage and production, with multiple instances of Apache running on Solaris
  • Wrote bash / perl scripts for routine server administration
  • Maintained user accounts and monitored overall status and health of the servers
  • Wrote Ant scripts for setting up web servers on all environments, dev, test, staging, and production
  • Wrote scripts to propagate application code changes across all the environments (dev/test/stage/prod)
  • Setup webgate in all the environments for identity management / Single Sign On (SSO), and worked closely with Business and Oracle Identity Management team (OIM) of NetApp for setting up authentication/access rules for different applications and different levels of customers
  • Worked closely with business and other client teams for setting up firewall rules, mounting and verify filer mounts
  • Worked closely with business to understand requirements and wrote technical specifications for development of cgi/perl applications
  • Owned / developed and maintained critical client applications written in cgi/perl
  • Provided Level 3 support for all issues related to infrastructure

Technologies: Web Server (Apache), WebLogic Server Administration, CGI, Perl, Oracle WebGate

Confidential, San Ramon, CA

System Administrator

Responsibilities:

  • Installed and configured Centos / Ubuntu and Debian servers
  • Built (virtual & physical)/ Configured/ Managed Web, Email and DNS High-Availability clusters using Ethernet Bonding
  • Administrating software Package like adding, deleting of software packages using aptitude (apt) / yum
  • Ensured 24x7 access and load-balancing of high-demand public-facing services. In order to achieve 99.999% SLA, the redundancy was provided at the hardware level (multiple mirrored servers), as well as at the network level (multiple WAN links)
  • Built / Configured / Managed MySQL High-Availability cluster using Circular Replication.
  • Built NAS storage High-Availability cluster using openfiler / DRBD
  • Built a comprehensive monitoring system using Nagios to monitor various mission-critical services across remote locations. The system monitors customers’ web-servers, mail-servers, databases, file-systems, firewalls, and networks
  • Developed a complex email control system in C++ to process and route email traffic between internet and customers’ mail-server. The application is seamlessly integrated with Exim (an SMTP gateway program), as well as MySQL database and NAS file-system
  • Providing customers a robust off-site infrastructure for email archival, compliance and disaster-recovery
  • User account administration
  • Used puppet for system configuration
  • Jira setup and administration, creating and tracking projects and related issues

Technologies: Ethernet bonding, Heartbeat, Perl, Debian Linux, DRBD, OpenFiler, NFS, Heartbeat, Puppet, Nagios, NagioSQL, SNMP, LAMP, emailToSMS, emailToPhone, C++, Exim, MySQL, NFS, TCP/IP Sockets, ClamAV, Bogofilter

Confidential, San Ramon, CA

Developer

Responsibilities:

  • Developed custom software for automating and streamlining the printing of lien notifications for Insurance companies
  • Gathered transaction data from SQL Server, verifying the mailing addresses against a master database, and consolidating the records according to lien-holder. Records were also sorted and grouped for the purpose of bulk-mailing
  • Technologies: SQL Server 2000, Visual Basic, Crystal Reports

Confidential, San Ramon, CA

Administrator

Responsibilities:

  • Web-Portal Content Management and Administration

Technologies: PHP, MySQL, JavaScript, HTML, Apache Web Server

We'd love your feedback!