Data Architect (Senior Analyst)
at Capco (View all jobs) Brazil - Sao Paulo
We are / have :
Capco is a global technology and business consultancy, focused on the financial services sector. We are passionate about helping our clients succeed in an ever-changing industry.
Experts in Brokerage, capital markets and banking
Deep knowledge in financial services offering, including e.g. Trading, Risk and Compliance, Core Banking etc.
Committed to growing our business and hiring the best talent to help us get there
Focused on maintaining our nimble, agile and entrepreneurial culture.
Conduce data modeling, as well as revise Data models, valuing name patterns, constraints, indexes, data dictionaries and logic consistencies.
Define the life cycle of data, analyzing impacts in entrance and exit from the database.
Define patterns and apply best practices in using Relational and Non-Relational Database
Conduce analysis about migration and operationalization of a Database to cloud servers.
Contribute with knowledge sharing about patterns and area process to the project team.
Create and revise the pattern and partitioning of tables.
Analyze the accesses and information security
Time of Professional Experience
4+ years professional experience.
Education / Certification
Bachelor’s degree in Computer Science, Computer Engineering, or related field
Able to demonstrate initiative and a proactive approach to daily tasks;
Self-motivated and able to take responsibility;
Ability to communicate solution design to teammates and clients;
Ability to deliver under tight deadlines and pressure;
Ability to align deliverables with the stated engagement objectives;
Punctual and reliable;
Able to build good relationships at all levels, internally and externally;
Able to interact with clients / business users directly;
Fluent in English and Portuguese.
Extensive experience with Oracle 11+
Experience in Data Modelling using tools (ERwin / ER Studio)
Experience in evolutionary data model methods that are consistent with Agile.
Experience with Flyway, Liquibase.
Experience in SQL and PLSQL is a must
Experience in Explain Plan and other optimization tools
Must be able to interact with Client and work through data model standard expectations both logical and physical
Experience monitoring, tuning and troubleshooting
Experience with database specific security Oracle
Experience using various flavors of Oracle’s replication mechanism
Experience creating and configuring Oracle from scratch
Must be able to communicate complex issues, concerns, etc. in lay terms
Must be able to not only inform technical colleagues, but willing to educate them