Elizabeth Cortés Email & Phone Number

Chicago, Il, Us

Rosemont, Illinois, United States

Administer and manage Azure SQL Databases, Azure SQL Managed Instances and On-Premises servers. Daily operational support of Azure Data Factory and pipelines that move data to data warehouses.Management of Azure SQL Data Storage accounts and blob containers managed by the Data Foundations team.Owning, tracking, and resolving database-related incidents and requests.Review service-related reports (database backups, maintenance, monitoring) daily to ensure service-related issues are identified and resolved within established SLAs.Design and implement proper access controls, authentication, and monitoring for our SQL platforms.Owning and managing data quality ensuring the best possible data accuracy. Performance tuning and database optimization to ensure efficient platform performance.

United States

Design and own database server-related infrastructure. Identify and design database-related solutions to business problems. Assisting developers in optimizing SQL code and stored procedures to ensure optimal SQL Server performance.Design, develop and publish SSIS Packages. Design, develop and publish SSRS Reports. Owning, tracking, and resolving database-related incidents and requests. Review service-related reports (database backups, maintenance, monitoring) daily to ensure service-related issues are identified and resolved within established SLAs. Respond to database-related alerts and escalations and work with database engineering to develop strategic solutions to recurring problems. Initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. Design solutions to further promote business objectives to generate revenue for the organization.Mentor and train junior SQL DBA members. Document and publish technical documents for projects and DBA team procedures.

Chicago, Illinois, United States

Ensures integrity, safety and availability of all data and applications as part of the Firm’s information systems. Develops, optimizes, and oversees Firm conceptual and logical data systems. Monitors system performance by performing regular tests, troubleshooting, and enhancements. Ensures that data strategies and architectures comply with policy, regulations, and governing laws. Oversees the mapping of data sources, data movement, interfaces, and analytics to ensure data quality and process consistency. Addresses data-related problems related to systems integration, compatibility, and multiple-platform integration. Creates data models that conform to existing standards and conventions; provides leadership and guidance with enterprise data strategies; revises data dictionary definitions, governance practices, and standards. Maintains and keeps systems and components up to date with the latest software releases and security patches. Manages and supports enterprise application systems as needed. Serves as a backup for enterprise application systems managed by other team members as needed.

Chicago, Illinois, United States

Monitors and supports SQL Server development and production environments. Responsible for SQL Server system security and application management, including change control management. Coordinates refreshes, releases, changes, and updates with the development team and OS administrators. Conducts performance tuning of SQL Server-based applications. Responsible for backup/disaster recovery procedures for database environments. Responsible for providing technical support and expertise to application developers. Responsible for finding and applying service packs, patches and fixes. Creates and implements system monitoring tools to ensure proper system and application performance levels. Designs relational database management systems (RDBMS) architectures. Responsible for fault diagnosis, system errors and corrections that occur with database systems. Responsible for Data modelling; SQL and stored procedure design and development; DTS, OLAP and replication design; build and support. Closely work with other groups in developing disaster recovery and business procedures. Designs logical and physical databases and works closely with development groups in web and client-server-based development initiatives. Works closely with IT Management in planning and creating an evolutionary strategy related to database design and performance within the Equity community.

Chicago, Illinois, United States

Lead Database Administrator responsible for the Firm's Microsoft SQL Servers and associated databases, including software installation, server configuration, database maintenance and query performance. Proficient in an assortment of database-related technologies. Document database designs and related processes. Tune databases and database queries for optimal performance. Fulfil availability and service level objectives associated with database systems. Participate in architecting proper solutions and HA/DR strategies for all firm solutions supported by SQL. Manage all SQL instances from version 2008 through 2016.