SQL Developer Resume Kansas - Hire IT People

SUMMARY

Five years of experience in Microsoft Database Technologies which includes Database Design, Programming, Administration, System Analysis, and Test.
Expert in installation, upgrade and configuration of MS SQL Server and databases in production and Development environments.
Design and document Logical and Physical data models.
Good knowledge of Relational Database Management systems(RDBMS).
T - SQL coding and testing: functions, views, triggers, cursors, dictionary, stored procedures, etc.
Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
Expertise in using data modeling tools like SQL Diagrams, Erwin, and Visio.
Experience in Database administration activities like Installation, Database designing, Query optimization, Performance tuning.
Good Knowledge on SQL LiteSpeed a Back Up solution for MS SQL Server.
Good in Implementing SQL Server change control process.
Good understanding of analyzing the queries with Explain plan and Execution plan.
Expertise in Query testing for high amount of data, JOIN sequence and indexes to be used.
A quick learner that strives for new technical knowledge.
A team player with strong leadership skills.

TECHNICAL SKILLS

Programming Languages: PHP, HTML, CSS, PERL, C, C++, Java, Java-script, Visual Basic

Database Technologies / Systems: Microsoft SQL Server 2005/2008, Oracle, MySQL, MS Access., PL-SQL, SQL-based CCL.

Software Tools: Putty, SVN, Filezilla, Quality Center, Intellinet, Navigator, VersionOne, Eclipse, Winrunner, Winscp, Bullzip, Wireshark, UML Rational Rose, Explorer menu, Discern Visual developer.

Web Development tools: WAMP Server, PHP CodeIgniter, WordPress, PHPBB3

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

SQL Developer

Confidential, Kansas

Responsibilities:

Write SQL scripts for Data extraction using the Microsoft DTS, SSIS.
Report generation to display the processed data using Crystal Reports and Microsoft Reporting Services (SSRS).
Understand requirements for implementation of new algorithm and prepare Design documents.
Write complex queries to manage high volumes of data.
Perform Query optimization and performance tuning for queries.
Write stored procedures, triggers and cursors.
Analyze Explain plans and Execution plans for Cost Based Optimizer(CBO) and Rule Based Optimizer(RBO) queries.
Perform Indexing and Hint the queries.
Execute Unit testing, Functional testing, Regression testing.
Follow Agile environment and involvement in improving code quality.
Work on highly paced work environment and meet the hard deadlines.
Mentor the new members on the project and provide them guideline to build their good learning curve of project.
Work independently to identify and resolve client side critical issues. Perform troubleshooting and bug fixing.

Environment: SQL Server 2005/2008, Cognos, Confidential Command Line(CCL)

SQL Developer

Confidential

Responsibilities:

Wrote bots (scripts) for email lookup of Orkut, Facebook, Bebo and LinkedIn using MS SQL Server 2008 and PHP.
Writing a script involves fetching large amount of data from different Social Media sites and process the data and store into databases.
Design and implement data models and SQL tables with all considerations of Primary key, Foreign key, Unique key, indexes.
Designed application for Orkut social site called zNotes to upload, download and sharing of files, pdfs etc.
Perform While box testing and Black box testing. Also write and document Test Cases.
Projects also involved use of PHP CodeIgniter which uses MVC architecture for Customer Relationship Management (CRM) system.
Designed and implemented using PHP and MS SQL Server 2008 a ‘Bid application’ where people can online bid for items. Also developed forums and blogs using PHPBB3 and WordPress.

Environment: SQL Server 2005/2008, MySQL, WAMP, PHP

We provide IT Staff Augmentation Services!

Sql Developer Resume

KansaS

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship