-- *Please send the resume to [email protected] <[email protected]> *
*Dear Partner,* *Alliedinformatics is a highly recognized provider of professional IT Consulting services in the US.* *Here is our open requirement which can be filled immediately. Kindly respond to this requirement with your consultant resume, contact and current location info to speed up the interview process.* Position :- SQL Developer Location :- Portland, OR. Duration :- 12 months Job Summary* (In three or four sentences summarize the job’s purpose and primary focus.) As a SQL Developer, plays an integral part in the implementation, design, testing and update of the SQL databases that support all the Provider Contracting and Relations systems. Provide technical leadership for major business application development/enhancement projects to ensure KPNW business information needs are met. Major Responsibilities/Essential Functions* (In order of importance, list primary job duties this position is responsible for achieving. Each statement should relate to an end result or objective.) Estimated % of Time Spent* Major Accountabilities % • Installation, administration and maintenance of SQL Server instances including Test, Dev, Staging and Production environments. • Create users and assign permissions based on the level of database access the user would need • Analyze technical requirements and design new data models or update existing data models • Analyze technical requirements and recommend ETL strategies and provide visual representation of designs • Ability to import data into SQL databases from multiple source types • Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server • Create database objects such as tables, views, stored procedures, triggers of high complexity to meet product requirements. • Create functions to provide custom functionality and enhanced performance as per the requirements. • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc. • Identify columns for Primary Keys in all the tables at the design time and create them. • Endure that the code is written keeping in mind any security issues and PHI • Develop reports in SQL Server Reporting Services. • Design, Develop and Deploy SSIS Packages. • Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications. • Create linked servers to SQL Servers and other databases such as Oracle, Access, Informix in order to support reporting requirements • Design database backup and restoration strategy and once created, monitor those backups are being performed regularly. From time to time recover the databases to a specific point of time, as per the requests. • Collaborate with NW Perm IT team with regards to any server requirements for the support of the databases, including VM sizing, failover, clustering, RAID, etc • Conduct Index and Performance Analysis to ensure products provide optimal performance • Deliver work products that meets specifications, are defect free, and have optimal performance • Build design consensus amongst different teams working on software development projects • Facilitate discussions among systems team to exchange ideas and introduce new database technologies • Evaluate emerging technologies to identify opportunities, trends and best practices that can be leveraged to strengthen KPNW technology platform and development practices. • Monitor SQL Server Error Logs to troubleshoot various problems that arise in a day-to-day work and fix the issues. • Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. settings, monitoring CPU usage and Disk I/O activity etc) Job Qualifications* Minimum Education (Indicate minimum education or degree required.) • Bachelor's degree in Computer Science, MIS, related field or equivalent experience. • 5+ years of related experience. • Certified DBA or equivalent knowledge and experience. Preferred Education (Indicate preferred education or degree required.) • Master’s degree in Computer Science, MIS, related field or equivalent experience Minimum Work Experience and Qualifications (Indicate minimum years of job experience, skills or abilities required for the job.) • Knowledge of SQL Server 2008 and 2012 features including indexing, synonyms, service broker, Change Data Capture, Change Data Tracking, CLR integration, partitioning, replication, and compression. • Experience with ETL tools • Experienced with multiple source data formats for import into the database • Experienced in XML development • SQL Server Relational Database Management System • Demonstrated knowledge of database design • Experienced in SQL SSIS, SSRS and SQL Server Analysis Services (SSAS) • SQL Development code writing efficiency • Ability to work independently and to manage multiple projects and priorities • Demonstrate excellent teamwork abilities • Ability to clearly communicate thoughts and ideas within and across teams. • Ability to work well with other developers and management. Preferred Work Experience and Qualifications (Indicate preferred years of job experience, skills or abilities required for the job.) • Healthcare experience strongly preferred, requires demonstrated understanding of business process as it relates to experience in the field. • 3+ years in software development environment as a Senior DBA • Experience in Java development preferred • Experience with stored procedures and performance tuning is a plus. • Expertise in multiple business units (service delivery, insurance, finance). Required Licensure, Certification, Registration or Designation (List any licensure or certification required and specify name of agency.) • Microsoft Certified Solutions Associate (MCSA) or Microsoft Certified Solutions Expert (MCSE) Certification Thanks & regards Moiz Khan Allied Informatics Inc. 1815 Satellite Blvd. Suite 302 Duluth, GA 30097 USA. Ph: 770-246-9800 x117 Fax No. 770-246-9098 Email: [email protected] <[email protected]> URL: www.alliedinformatics.com YM :- moizkhan_recruiter Gtalk :- recruiterkhan.it http://in.linkedin.com/pub/moiz-khan/29/952/1a6 Note : We respect your on line privacy. This is not an unsolicited mail.Please reply with Removal instructions in subject line incase your email address to be removed from this mailing list -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/open-source-j2ee-frameworks. For more options, visit https://groups.google.com/d/optout.
