SQL Security Framework Developer #29561 | SunGard | US-NJ-Parsippany-600 Lanidex Plaza; US-PA-Wayne-650 E. Swedesford Rd
SQL Security Framework Developer
| Job ID #: 29561 |
|
||
| Functional Area: Information Technology | Department: Operations - IT | ||
| Position Type: Full-Time Regular | Education Desired: BCS | ||
| Relocation Provided: No | Experience Desired: 5 to 7 yrs | ||
| Travel Percentage: 10 |
|
SQL Security Framework Developer SunGard requires a skilled Database Developer to support and develop databases in SQL Server 2008/12 environment, ensuring its peak performance and availability. This is a senior SQL Server Developer role largely responsible for providing operational database services to the Corporate Security organization. The ideal candidate for this position will have an in-depth knowledge of Microsoft T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and will use this experience to support processes in a production and pre-production environment. The ideal candidate will have an IT Security background with some working knowledge of the Classic.Net framework. Candidate is required to provide development and management support for the Information Governance Portal (IGP) back-end systems, data imports, automation and general SQL related tasks including installations. The candidate must posses the following experience: 1) 5+ years of experience as a SQL Server DBA/ETL developer 2) 5+ years information security 3) Strong development methodology adherence. 4) Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. 5) Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands 6) Experience in Database backup, disaster recovery, Snapshot, Merges and Transactional. 7) Design and develop ETL processes using SSIS. 8) Created complex DTS Packages for Data Migration and Transformation. 9) Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0 10) Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server. 11) Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS). 12) Working knowledge of SSRS 13) Working knowledge of Oracle DB including DB maintenance processes. 14) Windows server admin skills to help with troubleshooting/infrastructure support 15) Web/Classic.NET coding experience an advantage. 16) Strong verbal and written communication skills, with a strong customer service orientation and the ability to present ideas in user-friendly language 17) Highly self-motivated and directed Education/Experience: • Bachelors Degree and 3+ years related experience or training; or equivalent combination of education & experience • SQL 2000/2005+ Certifications a plus Travel: Appoximately 10% SunGard is one of the world’s leading software and technology services companies, with annual revenue of about $2.8 billion. SunGard provides software and processing solutions for financial services, education and the public sector. SunGard serves approximately 16,000 customers in more than 70 countries and has more than 13,000 employees. For more information, please visit www.sungard.com. |
|
|
Recruitment at SunGard Financial Systems works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. SunGard does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company. |
|
|
|
|
|
We are an Equal Opportunity Employer and do not discriminate against
applicants due to race, ethnicity, gender, veteran status, or on the
basis of disability or any other federal, state or local protected
class. Employment contingent upon successful completion of background investigation and pre-employment drug screen. As part of the selection process this role may require an assessment to determine suitability. |
