Stephen Singer Email & Phone Number

Ewing, Nj

Ewing Nj

Responsible for establishing database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. Work is substantially complex, varied and regularly requires the selection and application of technical and detailed guidelines. Regularly make recommendations to management on areas of significance to the department. Recommend new solutions to problems, to improve existing methods/procedures/services and generate new ideas. • Extensive work for Data Center migrations/consolidations with MSCS cluster servers and SQL Server databases from targeting virtual on premise farms and Amazon cloud EC2.• Expertise in Database Administration on Production Servers with server configuration, SQL Server best practices, performance tuning and maintenance with outstanding troubleshooting performance ability.• Expertise in SQL Server Backup/Recovery for local backups/NAS and tools: SQL Server, ArcServe and Veeam.• Experience in DR processes/planning including Log Shipping, Database Mirroring, Failover Cluster (WFCS), replication and Always-On.

Responsible for implementing database management systems and for ensuring the quality of database deliverables, such as database sizing plans, external data interface specifications, data loading plans, data maintenance plans and security policy implementations. Planned databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Establish and maintain security and integrity controls. Monitored policies, procedures and standards relating to database management. Proposed and implemented enhancements that improved the performance and reliability of the systems. Worked on problems of moderate scope where analysis of situations or data requires a review of a variety of factors. • Document and communicate database design. Adapt business requirements, developed by modeling/development staff and systems engineers, and develop the data, database specifications, and table and element attributes for an application.• Assist in the design of user interface and business application prototypes. Provide expertise in devising, negotiating and defending the tables and fields provided in the database. Determine how tables relate to each other and how fields interact within the tables for a relational model.• Install database management systems. Monitor file system space database allocation. Verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out of space conditions.

Responsible for ensuring accuracy and completeness of corporate databases and for effectively utilizing database methodologies, utilities, and tools. Maintained security and integrity controls. Monitored policies, procedures and standards relating to database management. Proposed and implemented enhancements that improved the performance and reliability of the system. Worked on problems of moderate scope and used standard practices and procedures as a guideline for analyzing situations or data. Responsible for developing new ideas and changes in methods, procedures, and services. • Developed database specifications, and table and element attributes for applications, including stored/remote procedure calls.• Coded basic to moderately complex programs and derive logical processes on technical platforms. Determined how tables relate to each other and how fields interact within the tables for a relational model.• Participated in quality assurance and application performance testing efforts.• Installed database management systems. Monitored file system space database allocation. Verified efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out of space conditions.

• Supported clients in numerous ways for Erwin and ModelMart interfaces to DMBSs, ODBCs and native connections. • Advised clients on how best the standard procedures of data modeling reflect the compatibility of the database. • Researched, identified and resolved problems/inconsistencies in client data models for both logical and physical database design in Erwin and ModelMart. Responsible for maintaining and troubleshooting stored procedures for Oracle, Sybase, SQL Server and other databases.

• Developed UNIX and NT shell scripts, C programs and SQL queries to administer client/host databases.• Customized and modified the performance of host databases to conform dynamically to client needs.• Researched, identified and resolved synchronization issues to ensure data integrity.• Administered host files systems’ integrity, transaction daemons and crons.• Modified and generated PC system table help files for laptop modules.• Received intensive Powerbuilder training in preparation for migration to Windows-based PC system.