System Administration, Mysql Dba Resume
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