Database Administrator - NA Service Delivery Group (USA)

5+ years of database administration experience Knowledge of database design principles and data modeling Knowledge of ETL processes and data warehousing concepts Knowledge of data security best practices Knowledge of Cloud based database services Knowledge of Agile development methodologies Knowledge of ITIL processes Bachelor’s degree in Computer Science/Engineering (or related field) or equivalent combination of relevant education and years of work experience Experience with Oracle and/or PostgreSQL (certifications are assets)

Design Database Structures: Create logical and physical database designs that meet application requirements and optimize performance. Develop Schemas: Define and manage database schemas, including tables, indexes, views, and relationships. Implement Data Models: Use Entity-Relationship (ER) diagrams and normalization techniques to ensure efficient data organization. Conduct Growth Projections: and capacity planning to accommodate future growth Installation: Utilize orchestration tools to ensure consistency on installs Write SQL Queries: Develop complex SQL queries to retrieve, manipulate, and analyze data effectively. Optimize Performance: Analyze query performance and implement indexing strategies to enhance data retrieval speed. Stored Procedures and Functions: Create and maintain stored procedures, triggers, and user-defined functions to automate tasks and enforce business logic. Implement Security Measures: Establish user roles and permissions to protect sensitive data from unauthorized access. Ensure Data Integrity: Use constraints, transactions, and validation rules to maintain accurate and consistent data. Monitor Database Performance: Regularly track database performance metrics to identify bottlenecks or issues. Tune Databases: Adjust configurations, indexes, and queries based on performance analysis to ensure optimal operation. Work with Application Developers: Collaborate closely with software developers to integrate database solutions with applications. Provide Technical Support: Assist development teams in troubleshooting database-related issues during application development. Conduct Database Testing: Implement testing procedures to validate database functionality, performance, and security. Debug Issues: Identify and resolve database errors or performance problems promptly. Root Cause Analysis: Write clear on concise reports on root cause of incidents. Manage Backups: Establish regular backup schedules to ensure data is securely backed up. Develop Recovery Plans: Create disaster recovery plans to restore databases in case of failure or data loss. Create Technical Documentation: Maintain comprehensive documentation of database designs, processes, standards, and procedures for future reference. Update Documentation Regularly: Ensure that all documentation reflects current practices and system configurations.