| State of NY Positions::::Onsite::Multiple Requirements(Sr.Oracle Data Warehouse Developer, Oracle BI Apps Developer,-$61DutiesSupport and development for the SFS Analytics Financial Data Warehouse. at Albany, New York, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1784118&uid= From: Ram, Soyo Soft Inc [email protected] Reply to: [email protected] Location: Albany NY (day 1 Onsite) Sr.Oracle Data Warehouse Developer - $61 Description Statewide Data Warehouse Developer Duties Support and development for the SFS Analytics Financial Data Warehouse. Analyze, design, build and test ETL components and data models for a BIApps Peoplesoft Financials data warehouse. Mandatory Requirements Experience (12+ Years) Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer. Requirements This is an 100% Onsite 84 months of experience in Business Intelligence apps programming reports 60 months of experience in OBIEE report development 60 months of experience in using SQL and Oracle PL/SQL 24 months of experience working in the State or Federal government with Oracle BI Apps for either PeopleSoft Financials, Procurement and Spend or Project Costing modeling 24 months of experience in RPD Maintenance Rsum Copy of Candidate Identification (i.e., Drivers License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Sr. Oracle BI Apps Developer - $61 Duties Support and development for the SFS Analytics Financial Data Warehouse. Analyze, design, build and test ETL components and data models for a BIApps Peoplesoft Financials data warehouse. Mandatory Requirements Experience (12+ Years) Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer. Requirements This is an 100% Onsite 84 months of experience in Business Intelligence apps programming reports 60 months of experience in OBIEE report development 60 months of experience in using SQL and Oracle PL/SQL 24 months of experience working in the State or Federal government with Oracle BI Apps for either PeopleSoft Financials, Procurement and Spend or Project Costing modeling 24 months of experience in RPD Maintenance Rsum Copy of Candidate Identification (i.e., Drivers License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Description The Division of Nutrition manages programs designed to improve the health and nutritional status of the residents of New York State. Improving the diet of the public is a key factor in improving public health among those most at risk for serious illness. Applications have been developed to meet the rising needs of the Division. Support and maintenance is necessary to keep these applications up and running, and to complete enhancements requested by end users. Duties Provide support for the administration and maintenance of SQL Server databases. Monitor applications use of the databases and make recommendations to improve efficiency and response time. Set up, monitor, and update jobs performing data backups and recoveries. Design and implement fast, scalable, and maintainable cubes. Monitor database usage, identify corrective actions when necessary and apply changes needed to handle data growth and performance degradation. Monitor database security and assign user access, grant permissions and roles, develop groups, audit access, etc. Perform impact analysis on hardware configurations, database schema, and application code, to offer recommendations on improving design and efficiency. Write SQL code via stored procedures and Transact-SQL to access data. Develop database design by performing needs analysis, creating logical model, and implementing the physical model. Follow/develop sound database practices. Ensure databases are available to users during business working hours and any routine maintenance is performed off hours. Install, configure, patch, and upgrade SQL Server. Monitor disk space utilization and logs and notify appropriate staff when additional resources are needed. Assist staff in setting up, maintaining, backing up and restoring databases in test and development environments. Implement and manage SQL Server database replication. Monitor replication to ensure the data is being properly replicated. Assist in reviewing and modifying a disaster recovery plan that allows for continuation of service. Run database jobs, i.e. reorgs, imports and exports, backups, etc. Troubleshoot issues and take corrective actions as needed. Monitor data integrity to ensure data is not damaged and/or corrupt. Create and maintain documentation related to all tasks and provide mentoring/knowledge transfer to other staff within the Database group. SQL Server Architect - $68 Mandatory Requirements Experience (14+ Years) Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. Requirements This is an 100% Onsite 84 Months of experience establishing, maintaining and troubleshooting SQL Server DBMS in an enterprise-wide database within a Windows environment 84 Months of experience establishing, maintaining and troubleshooting SQL Server DBMS that utilize High Availability in a Windows environment 84 Months of experience designing and implementing fast, scalable, and maintainable cubes. 60 Months of experience performing SQL Server optimization analysis and implementing resolutions. 60 Months of experience performing working with Transact SQL and SQL Server Data. 48 Months of experience working with end users providing DB support. 48 Months of experience performing optimization analysis and implementing resolutions in SQL Server Analysis Server. Bachelor's Degree Rsum Copy of Candidate Identification (i.e., Drivers License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) -- Thanks & Regards, Ram, Sr Lead Recruiter/Bench Sales, 574-318-0922 Soyo Soft Inc. Fax: 516-644-5401 Keywords: business intelligence database rlang procedural language New York State of NY Positions::::Onsite::Multiple Requirements(Sr.Oracle Data Warehouse Developer, Oracle BI Apps Developer,-$61DutiesSupport and development for the SFS Analytics Financial Data Warehouse. [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1784118&uid= |
| [email protected] View All |
| 10:14 PM 25-Sep-24 |