Database Administrator - Senior

Location

Canada

Posted

3 days ago

Salary

0

Seniority

Senior

No structured requirement data.

Job Description

Database Administrator - Senior

ITProFound Inc

Role Description We do have a job opening for Database Administrator - Senior for our direct client Province of Ontario. The position details are given below: - Creates and implements physical database designs and operates and administers the database management system (DBMS) including: - Database optimization - Capacity planning - Installation and migration - Database design - Performance tuning - Backup and recovery - Maintain and monitor a number of Oracle 10g, 11g, 12c, 19c databases in large multi-tenant environments including: - Database administration - Maintenance - Optimization - Migration - Fine tuning of databases - Design, build and configure Oracle Database Servers on: - Windows - Solaris - Linux - Lead and design solutions for enterprise Oracle migration project to migrate to 19c or higher. - Carry out complex/specialized systems analysis and design for success of Oracle migration. Company Description

Related Categories

Related Job Pages

More Database Administrator Jobs

Part TimeRemoteTeam 51-200H1B No Sponsor

• Advanced use of Excel • Build reports and manipulate data • Consult with executives to identify improvement opportunities • Collaborate with team members to analyze data • Visualize data with graphs and infographics • Establish KPIs for decision effectiveness • Structure large data sets • Process information with a team • Craft presentations based on findings

United States
Mastercard logo

Senior Database Administrator

Mastercard

Founded in 1966, Mastercard is a worldwide transaction, payment-processing, and consulting company best known for its line of personal and business credit cards. As an employer, Ma

Full TimeRemoteTeam 38,800Since 1966

Our Purpose Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential. Title and Summary Senior Database Administrator Who is Mastercard? Mastercard is a global technology company in the payments industry. Our mission is to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments, and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. With connections across more than 210 countries and territories, we are building a sustainable world that unlocks priceless possibilities for all. Overview Database Engineering manages our databases with a goal to deliver secure, scalable and resilient infrastructure and software deployment capability for global solutions. Provide administration of production, pre-production, UAT and development database systems and assist in designing of the database tier for our global systems Provide a robust, scalable and high-performance production database environment working with system engineers, database developers and other database administrators Role The Senior Database Engineer role has the ability to perform engineering functions where the individual contributes and/or influences the strategic direction for the Database Engineering Program. The individual will build a strong partnership with management and may manage operational and/or strategic initiatives or support for the team. The Lead Database Engineer champions the Mastercard Way. About you• Advanced hands-on experience in configuring, patching, upgrading, and optimizing database software and related products.• Advanced experience in security, backup/recovery, architecture, networking, and administration for assigned database discipline.• Expertise and deep understanding in Database Replication setup, configuration, troubleshooting both Physical as well as Logical Replication• Proven track record in working with technology teams for the development, maintenance, testing, implementation, and support of assigned database technologies and associated software products.• Proactively monitor with advanced troubleshooting skills for database issues escalated by the business team and internal monitoring in a timely manner with strong skills to drive to root cause and remediation of issues.• Ability to develop a strong partnership with technology teams and customer to understand business needs and with advanced skills to communicate solutions in business terms.• Strong to advanced performance and tuning skills with the ability to identify, respond and resolve database performance issues; communicates database performance resolution to technical teams and business partners.• Successfully follow change management, problem management and incident management processes and procedures.• Experience with IAC Automation tools for building automation for DB builds, Patching, maintenances• Ability to handle large to enterprise project/initiatives with specialized knowledge within assigned discipline and the ability to architect solutions.• Advanced written and verbal communication skills to promote Database Engineering.• Proven track record to proactively plan and coordinate larger technical and architectural efforts within the database team and with external technology teams.• Ability to influence Mastercard best practices in planning, coordinating, implementing, and maintaining database solutions.• Proven track record in training and mentoring members of the team by contributing to supporting documentation.• Communicate, collaborate, and work effectively in a global environment.• Creates a positive culture in Database Engineering following the Mastercard Way. Corporate Security Responsibility Every person working for, or on behalf of, Mastercard is responsible for information security. All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and therefore, it is expected that the successful candidate for this position must:• Abide by Mastercard's security policies and practices• Ensure the confidentiality and integrity of the information being accessed• Report any suspected information security violation or breach, and • Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines. **Desirable Knowledge/Experience**• Experience integrating vendor and open-source products into an overall system• Experience working on cloud-hosted services like AWS, Azure• Database Technologies Include (not limited to): PostgreSQL, Oracle, Cassandra/Elastic Search, Redis, MongoDB, SQL Server, Oracle Exadata Administration, Graph DB. The ideal candidate should have experience in both RDBMS and NoSQL database technologies Corporate Security Responsibility All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must: - Abide by Mastercard's security policies and practices; - Ensure the confidentiality and integrity of the information being accessed; - Report any suspected information security violation or breach, and - Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines.

Ireland
Peraton Corporation logo

AWS Database Administration

Peraton Corporation

Peraton Corporation, a national security company headquartered in Herndon, Virginia, supplies solutions for mission-critical programs and systems. Founded in 20

• Develop and implement data ingestion solutions using AWS database and cloud-native technologies. • Design, administer, and optimize relational and NoSQL database environments, including Amazon RDS (PostgreSQL, Oracle), Amazon DynamoDB, Amazon Redshift, Amazon Athena, and Amazon S3. • Utilize AWS Database Migration Service (DMS) to migrate, replicate, and modernize database environments. • Research, evaluate, and recommend AWS data storage architectures and database technologies to support business and technical requirements. • Design, develop, test, deploy, and automate database solutions, including infrastructure and database build processes. • Develop automation and administrative scripts using Python and/or Bash. • Monitor database usage, performance, and capacity; conduct performance tuning and provide recommendations for system optimization. • Design and implement indexing strategies, replication, backup, and disaster recovery solutions across multiple AWS Regions. • Develop, test, implement, and maintain SQL code, stored procedures, database applications, and other database objects. • Design scalable, secure, and resilient data models supporting transactional, analytical, and hybrid workloads. • Design, build, and support cloud-based Data Lakes, Data Warehouses, and modern enterprise data platforms. • Lead the design and implementation of modern database architectures that support cloud migration and application modernization initiatives. • Maintain database security, access controls, and data integrity to protect organizational information assets. • Develop and enforce database administration policies, standards, procedures, and governance practices.

Maryland + 2 moreAll locations: Maryland | Virginia | Washington
$135K - $216K / year

Database Developer

Tria Federal

Tria Federal, founded in 2023, is a technology and advisory services firm specializing in digital transformation solutions for the federal sector. Guided by its commitment to servi

Role Description Tria Federal (Tria) is seeking a talented Database Developer for a key FEMA system. In this role, you’ll be responsible for the evolution of data, including maintaining and improving dozens of SQL scripts, streamlining our data operations, and maintaining our database to ensure peak performance. Qualifications - 7+ years of experience (or 11 total years without a Masters) - Master’s Degree in Information Systems, Computer Science or Computer Engineering or a related discipline - US Citizen - Ability to work in a highly functioning Agile team - Proven track record using MS SQL Server database, creating complex stored procedures, functions, views. Experience with Azure SQL Database is a plus. - Strong communication skills and comfortable presenting to customers both virtually and in-person. - Ability to thrive and create professional resolutions in adverse situations with minimal guidance or oversight. - Computer proficiency, including Microsoft Office tools (Word, PowerPoint, Excel, Project) - Demonstrated ability to write large, complex, high-performing queries. Requirements - Create, improve, and debug scripts to build, move and modify database objects, automating where possible. - Develop complex stored procedures, functions, triggers and views. - Design logical and physical data models along with preparing and presenting statistical information for both internal and external use. - Collaborate with Application Developers to implement best practices with database, statement, and query design. - Providing support, guidance and collaborating with Application Developers to implement database design, and review developer’s work to ensure correct implementation. - Create and apply optimization strategies. - Assist with schema design, code review and query tuning. - Upgrade and improve data and application schema, preparing design documents and functional specifications. - Work in conjunction with the engineering and data science teams to resolve issues, evaluate software modules, and develop appropriate specifications. Benefits - Top-tier benefits package to invest in your physical, mental, and financial health and wellness. - Opportunities to learn new skills, seize new challenges, and advance your career as we grow.

United States