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.
• 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.
• 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.
• 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.
• 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.
• 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.

• 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.