The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
M136xs6xshh1sh0tv83

SQL Developer

Job Description

Morgan, Lewis & Bockius LLP, one of the world’s leading global law firms with almost 4,000 lawyers and staff in 30 offices is seeking a SQL Developer. Reporting to the Senior Manager of Database Services the SQL Developer will be responsible for designing, developing, deploying, testing, and maintaining ETL, T-SQL, and Report solutions in support of various applications. He/She serves as the main point of contact for IT internal and external ETL/Report requests. In this role, He/She would closely work with a team of data analysts, application developers, and business users while under the direction of database services.

PRIMARY FUNCTIONS AND RESPONSIBILITIES

Responsibility
Primary functions for this role include:

• Serves as the principal point of contact for SSIS, T-SQL, and SSRS developments.
• Works with business stakeholders to define requirements for ETL and SSRS Reporting needs.
• Develops and implements data integration flows (ETL) using SQL Server Integration Services.
• Creates and modifies complex reports within SQL Server Reporting Service; maintains and supports existing reports and implementation of enhancements.
• Designs, develops, and maintains database tables, views, stored procedures, functions, and supporting objects.
• Troubleshoots and corrects production ETL/Report issues.
• Optimizes stored procedures, T-SQL, views, and functions for the best performance.
• Refines and automates regular SQL processes, track issues, and document changes.
• Creates and maintains technical documentation as required by standards and policies
• Collaborates with internal and external Clients as well as Developers and Business Analysts to define and understand technical requirements of clients.
• Participates in design and code reviews and ensure adherence to best practices.
• Provides after hours support for scheduled deployment activities and critical issues as needed.

EDUCATION AND EXPERIENCE

This job requires:
• Bachelor's degree (B. A.) from four-year college or university
and,
• Minimum 5 years of IT experience; 3-4 years of RDBMS system with an emphasis on developing, implementing, and maintaining ETL using SSIS and Reports using SSRS; three years of back end application development and design using SQL, stored procedures, functions, views, and triggers.

or, an equivalent combination of education and experience.

OTHER QUALIFICATIONS AND REQUIREMENTS:
To perform the job successfully, an individual must demonstrate the following knowledge skills and abilities:

• Analytical experience in gathering business requirements to produce technical design documentation for reports.
• Written communication skills
• Verbal communication skills
• Strategic thinking
• Self-starter
• Planning/organizational skills
• Problem-solving skills
• Good understanding of Microsoft SQL server internals
• Experience with Online Transaction Processing (OLTP) using Microsoft SQL Server
• Expertise with SQL Server 2012 / 2014 / 2016 Reporting Services (SSRS), Integration Services (SSIS)
• Expertise in SQL and stored procedure tuning
• Ability to adapt to change and balance competing demands
• Ability to read and interpret general business documents, instructions and manuals, write routine business correspondence, and speak effectively with employees, clients
• Advanced arithmetic skills (compute rate, ratio, percent; able to draw and interpret graphs and charts)
• Ability to solve practical problems, dealing with a variety of variables where little standardization exists

COMPUTER SKILLS

To perform this job successfully, an individual must be proficient in the following software:

Document Management: MS-Office (MS Word, PowerPoint, Excel)

Database Software: SQL Server 2014, 2016, SSIS, SSRS

• Microsoft Technology Associate (MTA): Database preferred but not required.

Qualified candidates must apply online by visiting our website at www.morganlewis.com and selecting “Careers.”

Morgan Lewis is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment qualified applicants with arrest and conviction records.

Job Requirements

 

Job Snapshot

Location US-PA-Philadelphia
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

Morgan, Lewis & Bockius LLP

At Morgan Lewis, we work in collaboration. We provide comprehensive litigation, corporate, finance, restructuring, employment and benefits, and intellectual property services in all major industries, helping clients address and anticipate challenges across vast and rapidly changing landscapes. With offices in North America, Europe, Asia, and the Middle East, we work with clients ranging from established, global Fortune 100 companies to enterprising startups. Learn More

Contact Information

US-PA-Philadelphia
Icon-social-facebookIcon-social-linkedinIcon-social-twitter
Snapshot
Morgan, Lewis & Bockius LLP
Company:
US-PA-Philadelphia
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

Morgan, Lewis & Bockius LLP, one of the world’s leading global law firms with almost 4,000 lawyers and staff in 30 offices is seeking a SQL Developer. Reporting to the Senior Manager of Database Services the SQL Developer will be responsible for designing, developing, deploying, testing, and maintaining ETL, T-SQL, and Report solutions in support of various applications. He/She serves as the main point of contact for IT internal and external ETL/Report requests. In this role, He/She would closely work with a team of data analysts, application developers, and business users while under the direction of database services.

PRIMARY FUNCTIONS AND RESPONSIBILITIES

Responsibility
Primary functions for this role include:

• Serves as the principal point of contact for SSIS, T-SQL, and SSRS developments.
• Works with business stakeholders to define requirements for ETL and SSRS Reporting needs.
• Develops and implements data integration flows (ETL) using SQL Server Integration Services.
• Creates and modifies complex reports within SQL Server Reporting Service; maintains and supports existing reports and implementation of enhancements.
• Designs, develops, and maintains database tables, views, stored procedures, functions, and supporting objects.
• Troubleshoots and corrects production ETL/Report issues.
• Optimizes stored procedures, T-SQL, views, and functions for the best performance.
• Refines and automates regular SQL processes, track issues, and document changes.
• Creates and maintains technical documentation as required by standards and policies
• Collaborates with internal and external Clients as well as Developers and Business Analysts to define and understand technical requirements of clients.
• Participates in design and code reviews and ensure adherence to best practices.
• Provides after hours support for scheduled deployment activities and critical issues as needed.

EDUCATION AND EXPERIENCE

This job requires:
• Bachelor's degree (B. A.) from four-year college or university
and,
• Minimum 5 years of IT experience; 3-4 years of RDBMS system with an emphasis on developing, implementing, and maintaining ETL using SSIS and Reports using SSRS; three years of back end application development and design using SQL, stored procedures, functions, views, and triggers.

or, an equivalent combination of education and experience.

OTHER QUALIFICATIONS AND REQUIREMENTS:
To perform the job successfully, an individual must demonstrate the following knowledge skills and abilities:

• Analytical experience in gathering business requirements to produce technical design documentation for reports.
• Written communication skills
• Verbal communication skills
• Strategic thinking
• Self-starter
• Planning/organizational skills
• Problem-solving skills
• Good understanding of Microsoft SQL server internals
• Experience with Online Transaction Processing (OLTP) using Microsoft SQL Server
• Expertise with SQL Server 2012 / 2014 / 2016 Reporting Services (SSRS), Integration Services (SSIS)
• Expertise in SQL and stored procedure tuning
• Ability to adapt to change and balance competing demands
• Ability to read and interpret general business documents, instructions and manuals, write routine business correspondence, and speak effectively with employees, clients
• Advanced arithmetic skills (compute rate, ratio, percent; able to draw and interpret graphs and charts)
• Ability to solve practical problems, dealing with a variety of variables where little standardization exists

COMPUTER SKILLS

To perform this job successfully, an individual must be proficient in the following software:

Document Management: MS-Office (MS Word, PowerPoint, Excel)

Database Software: SQL Server 2014, 2016, SSIS, SSRS

• Microsoft Technology Associate (MTA): Database preferred but not required.

Qualified candidates must apply online by visiting our website at www.morganlewis.com and selecting “Careers.”

Morgan Lewis is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment qualified applicants with arrest and conviction records.

Job Requirements

 
Mxh18f6r4rs1wkmz6h7
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
SQL Developer Apply now