Pitney Bowes Senior Database Engineer in Shelton, Connecticut
Senior Database Engineer
Pitney Bowes Inc. has an opening for a Senior Database Engineer in Shelton, CT.
Work on high performing database applications and review, recommend and modify developers’ database design and changes. Design, maintain and support new and existing non-production and Production database environments in a DevOps environment. Help improve efficiency and streamline database changes processes and automate production data refreshing in Development, QA, staging and production environments. Translate business and product requirements into system requirements, and work closely with PM, SME, and developers to design, implement database sub systems. Design, maintain and build logical and physical database models. Maintain and implement database change control, release process for all non-production to Production environments. Help and work with customer service personnel to resolve centralized or customer hosted database escalation/issues. Plan and conduct structured testing of database designs to confirm functionality and performance, optimize and tune database schemas, stored procedures, triggers, dynamic queries, and work with developers to implement complete solutions. Develop and maintain documentation related to database development based on policies, guidelines and standards, as well as database integrity, security, HA, and DR planning. Work on High Availability database technologies like Always On, Peer to Peer replication and Disaster recovery technologies like Mirroring and Log shipping. Design, Implement and deploy SQL SERVER SSIS packages as part of ETL and database archival solutions.
Must possess at least a bachelor's degree or its equivalent in Computer Science, Computer Engineering, Information Systems or a related field and at least six years of prior progressive work experience with database design and implementation. Must also possess the following: at least 6 years of experience with EACH of the following: SQL Server 2008/2012/2014/2016; source control systems, database versioning and release processes; database schema design, database design/implementation best practices, performance tuning and optimization using native monitoring and troubleshooting tools; large database batch jobs, data transformations, T-SQL, stored procedures, triggers, database backups and restores; RDBMS, Database partitioning, log shipping, SSIS and data encryption; and internal structure of indexes, statistics and system information schemas; at least 4 years of experience with Data warehouse, SSRS design and development; and at least 3 years of experience with Linux/AWS MySQL 5.6.
Apply online at https://careers.pitneybowes.com/
Job: Information Technology
Title: Senior Database Engineer
Requisition ID: 178584