Post Job Free

Resume

Sign in

Sr SAS Developer & Analyst

Location:
Iselin, NJ
Salary:
120k
Posted:
May 17, 2011

Contact this candidate

Resume:

Niharika

917-***-****

gxwd4e@r.postjobfree.com

Professional Summary:

Over 5 years of experience in Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade and migration.

Highly experienced in managing high availability of production systems for Corporate Sectors and Individual Organizations as DBA and PHP programmer.

Experience as Drupal developer/architect programming in versions 4, 5 and 6.

Experienced in creating PHP scripts to solve complex MySql task and managing servers across multiple data centers.

Expertise in MySql, Oracle skills and significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient in writing shell scripts as well as knowledge in general systems administration tasks.

Expertise documentation skills with the ability to meet project deadlines and has the ability to work in a cross functional environment.

Highly experienced in designing, modeling, developing and supporting database management systems (DBMS).

Implemented and maintained MySql, Oracle on different Unix Operating systems like Redhat, Fedora Linux.

Experienced in quickly diagnosing server problems and employed preventive measures to maintain high availability servers

Extensive experience on Oracle, MSsql server and PostgreSQL databases

Highly experienced in providing software deployment as a service (Saas).

Experience includes Database Design, Analysis and Development with MySQL .

Expert in handling MySql processes, security management, and queries optimization.

Excellent knowledge in Object Oriented Concepts (OOP)

Well versed with complete Software Development Life Cycle (SDLC) process which includes Designing, Developing, Testing and Implementation.

Experienced in developing e-commerce applications using AJAX.

Experienced in IDEs like Dream weaver, Eclipse, Microsoft Visual Studio and Zend studio.

Extensive experience with Content Management Tools such as Drupal and Joomla.

Experienced in Search Engine Optimization and highly experienced in working with all the MySql GUI tools.

Expert in performing backup and recovery procedures.

Expert in scharding and federation of databases.

Experienced in all points of application development processes, including: database design, user interface, e-commerce, security, web services, server administration, and quality assurance.

Familiar with Web Service platform elements like SOAP and WSDL.

Proficient in Flash CS3 and Action Script 3.0 for creating graphical animations.

Expert in implementing PayPal payment system for secured transaction.

Excellent written and oral communication skills with a results-oriented attitude.

Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

Education Qualifications:

Masters in Computer Engineering

Skillset:

PHP 4/5, MySQL4/5, Oracle 8i, 9i, 10g, LAMP, WAMP, PHPMYADMIN, Zend Framework, HTML, XHTML, CSS, JavaScript, Jquery, DHTML, AJAX, XML, XSLT, Web Services, ASP dotnet, C# dotnet, C++, C, SQL, PL/SQL, SQLyog, WordPress, Microsoft FrontPage, Symfony, Dreamweaver, Flash, Adobe illustrator 1.6 2.0 4.0, Photoshop, Joomla, Drupal and Smarty. Unix SCO, Sun Solaris, AIX, SSH, SSL, Apache, PostgresSQL, Red Hat Linux, Replication, Clustering, Tuning, Backup, Recovery.

Projects Summary:

IPC Systems

MY-SQL DBA

Project: Unigy 2/2010-Present

IPC has delivered innovation and mission-critical trading technology and connectivity solutions to financial market participants’ globally.IPC is committed to providing essential and seamlessly aligned technology and network services that enable the business of the trading and brokering community.

Hardware/Software:

MySQL 5.1/5.4,Java, Java Scripts, RedHat 2.5,WebLogic 8.1,Ecplise 3.5, Data Comparator, Coro sync.

Responsibilities:

Involved in creating Data-Model, Created the logical and physical relationship model diagrams.

Used the model XSD to create entities and database schema.

Involved in weekly data model spec meetings and discuss the schema changes and validate it so that they are available for the build.

Created the architecture for the Master-Master replication and high availability solutions.

Responsible for writing shell scripts to attain the required functionality in the areas of replication, database backup and restore.

Responsible for maintaining the dataset and update it according to the changes by the focus groups and maintains the dump on the repository server.

Responsible for setting up the replication environment to test the BCP zone, high availability and HQE.

I was also be responsible for the Mysql instllation on different servers using the cop image installation.

Responsible for packaging different RPMs for database creation scripts as well as data installation.

I was available to solve different issues coming up in installation of databases and different issues coming up in login and security.

Responsible for creating the database users and set passwords for them and give privileges to the users so that they will be able to login and read the data they wanted.

Responsible for writing the stored procedures, Triggers, views for different purposes and contracts obtained from the focus groups.

Responsible for solving the database issues coming up in the development as well as QE testing environment.

Was a core member in the HA meetings to discuss the requirements on the Mysql replication scripts and JCS replication scripts and see that they are in place

Iowa Foundation for Medical Care, Des Moines, Iowa 3/2009 – 1/2010

My-SQL Developer/ DBA

Iowa Foundation for Medical Care (IFMC) has been dedicated to health care quality improvement and medical information management. IFMC is an innovative industry leader in improving the quality, service and cost of health care. The objective of the project is to develop employee’s pay-roll system using Drupal as CMS and also maintain the security of website using PHP scripts.

Hardware/Software:

MySQL5.1/5.0, PHP Oracle 9i, XHTML, JavaScript, Wordpress, SqlYog, PHPMYADMIN, VSS, Window XP, LAMP, Microsoft Visio 2007, Drupal and Symfony 1.3 and 1.4.

Responsibilities:

Automated Data Import Script using shell scripting, PHP, MySQL and regular expressions.

Created, tested, and maintained PHP scripts, forms, reports, triggers and procedures for the Data Warehouse.

Performed PHP coding on Web applications that are driven by MySQL database.

Created database application using PHP and Mysql as the database to monitor customer profiles and complaints.

Implemented MySQL database backup, recovery strategies, Replication and synchronization.

Assisted in creating a new set of database users to involve in better logging of errors along with better overall security.

Identified and implemented missed SEO opportunities that increased site traffic exponentially.

Implemented PHP session variables and cookies to maintain accuracy.

Converted databases from MyISAM format to Innodb storage engine for databases that needed greater referential integrity.

Upgraded servers to newer versions of MySQL as needed for security and enhanced performance.

Used Symfony in order to accelerate the creation and maintenance of websites.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Troubleshooted performance problems over phone and via email.

Worked with development teams for performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.

Created/Maintained/Tested mySQL master/slave replication both on the client side and the Web sites.

Designed and developed several web and GUI products for commercial distribution.

Recovered the databases from backup in disasters.

Performed scharding and federation of MySql databases.

Assisted in creating reports using ETL tools to keep the developers focused on new business development and maintenance.

MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.

Migrated Oracle 9i databases to MySQL using the MySQL Migration Toolkit.

EBE Technologies, Moline, IL 8/2008-2/2009

PHP, My-SQL Developer/ DBA

EBE is the leading provider of integrated business process management trucking software designed specifically for the industry. Customer list includes more than 300 leading transportation companies in North America. Their expertise in imaging, document and content management and trucking software has led to the development of enterprise solutions. The project involved redesigning and maintaining the website with recent updates using PHP and included a secure Drupal tool.

Hardware/Software:

MYSQL 4.1, MySQL 5.0, PHP5, Oracle 10g, XHTML, CSS, Flash, Photoshop, LAMP, PERL, VSS, Microsoft Visio 2003, Adobe illustrator 1.6

Responsibilities:

Created the initial design to determine the look and feel of the website by creating wireframes using Axure, mockup UI’s.

Embedded PHP, HTML, and JavaScript Validations.

Developed search engine using AJAX.

Collected specifications from client and designed the templates using PHP.

Developed administrator module to provide the back end features of the website using PHP.

Developed interactive web applications using techniques such as Scripting, DHTML, and Ajax with YUI library of JavaScript.

Created user verification and email subscription forms using PHP.

Involved in site architecture and infrastructure, backend development using open source toolset PHP, PostgreSQL, MySQL, Apache, Linux and others.

Created User registration module for new users and login feature for existing users on Front-End.

Designed consumer mash-up like Google map.

Extensively used JavaScript for adding interactivity to the web pages, Adobe illustrator and Photoshop for adding graphic images.

Involved in development of manufacturing, education, and developer applications using Java, PHP and Drupal, and SEO for website.

Implemented the database model in MySQL and implemented sessions to maintain data state.

Created and managed database tables like customers, orders, products using MySQL.

Implemented and managed a cluster of load-balanced, high-availability MySQL servers for hosting commercial and internal Web sites.

Managed access control and permissions for all users with MySQL internal tables.

Granted and revoked access to users and IPs. Designed and built a network operations center including: selecting servers, routers, switches, and operating systems. Network is load-balanced, redundant, and fault-tolerant throughout, including databases, email, Web, and FTP services.

Upgraded servers from Oracle9i to 10g. Standardized Oracle install to make it easier to add new servers.

Performed query analysis for slow and problematic queries.

Performed unit testing of the modules, debugged and fixed errors and bugs.

Deployed and configured LAMP.

Involved to resolve cross browser development issues using web development tools and internet explorer.

Volga Solutions HYD,India 07/2006 - 06/2008

PHP, MYSQL Developer/ DBA

Volga is the nation's fourth largest broad line retailer. They are the nation's largest provider of home services, with more than 12 million service calls made annually. The objective of the project is to create a website to store the user’s personal details and to create shopping cart for user to make shopping easy using a php tool called PayPal. It also aims to design an intranet website for employees to handle various issues.

Hardware/Software:

MYSQL 4.1, PHP 4, HTML, CSS, PHP, MYSQL, JavaScript, Smarty, Pear, MS Visio, Adobe Photoshop, Dreamweaver, PhpMyAdmin.

Responsibilities:

Handled the technical escalation related issue from 1st line at high priority and on call 24*7 support to team for DB issues.

Made shell scripts for data extraction from the raw data (Logs) as per required by the clients.

Database designing including query analysis and index optimization.

Implemented, installed MySQL DB and support of software products at the client site and involving client interactions.

Responsible for optimizing data access through Partitiong (Sharding and Federation).

Optimized the DB schema and query analysis.

Created Report Generator that queried the MySQL database for user-specified information.

Implemented Third Party online chat Server to enable Customer to Help Desk open-chat communication.

Implemented secured online credit card transactions.

Involved in designing the shopping cart.

Implemented Third Party Payment Gateway using PayPal for secured transactions.

Involved in Database design, application design, and site architecture design, CSS, JavaScript and HTML programming to meet validation requirements.



Contact this candidate