Database Solution Architect

Company: Wipro Ltd.
Location: Harrisburg
Posted on: March 26, 2020

Job Description:

Wipro is seeking a Database Solution Architect to be part of a dynamic team to support our customer technologies. This role will allow you to provide technical mentoring to the current team members, execute the best practices to enable database migration to cloud. Responsibilities Design a solution to migrate a large multi-tenant, multi-site Postgres database in a J2EE environment from on-prem to AWS cloud. Plan, architect, and guide delivery of critical, complex database features at enterprise scale, including purgearchive, backuprecovery, data refresh, and overall database architecture and scalability. Develop and enforce standards for database design and development best practices, and design tools to enforce these practices at scale. Critically assess the risks and provide mitigation solutions for the database migration from Db2 to Postgres Analyze, document and recommend on possible approachesalternatives like StreamedReplicationSeamless approaches. Collaborate with development and operations leadership to identify data tier feature gaps, improvement opportunities, and proactive enhancements to increase quality of service. Participate in the evaluation, selection and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing Qualifications Expertise more than one major relational database (preferably PostgreSQL) such as Oracle, SQL Server, MySQL, Aurora, etc. Expert knowledge of database architecture and implementation planning and execution, and demonstrated delivery of enterprise-scale database in AWS cloud with scale of more than 12K transactions per second 4-5 years of experience managing complex bi-directional replication topology Strong understanding of PostgreSQL streaming and logical replication Strong understanding of PostgreSQL database security management Expert-level understanding of database query tuning and optimization Candidate should come from a combination of Core-Development and DevOps background and Large-Scale Data handling and SQL (32+ TB), including tuning at all levelstiers background. Deep expertise in authoring, building and adopting large scale, cross-functionaldata migration methodologieswith well-balanced coverage across mainlyRDBMS and mainframe Cloud legacy modernizationlevels Executive-level communication abilities and able to explain complex deployment topics to both non-technical and technical staff Experience with DB2 is a plus

Keywords: Wipro Ltd., Harrisburg , Database Solution Architect, IT / Software / Systems , Harrisburg, Pennsylvania