Database Cloud Architect Resume
2.00/5 (Submit Your Rating)
New York, NY
SUMMARY:
- Dedicated and motivated professional with a strong background in Databases Management development and optimization.
- 18 Years of successful experience contributing on multifaceted database projects, fostering positive relations with a wide range of key business partners.
- Consistently recognized for outstanding contributions to the bottom line. Solid reputation for resolving complex issues.
- Commended for perseverance, efficiency, and project management skills.
TECHNICAL SKILLS:
Databases: MS SQL Server, MySQL
Programing: SQL/T - SQL, Python, PowerShell, Ruby
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Database Cloud ArchitectResponsibilities:
- Lead a team of DBA’s in the designing, implementing, and supporting enterprise applications supporting TV broadcasts, Ad sales, International Distribution, Data Warehousing and Analytics
- Responsible for databases services supporting 20 applications across 100s of database servers. Supporting TV content delivery Ad Sales and back-office application On-prem, on AWS EC2 and RDS and Azure.
- Established enterprise standards, guidelines, procedures, and processes. Governed security, physical design, engine configuration, backup and recovery.
- Installed, configured, and maintained hundreds SQL Servers using PowerShell for automation.
- Team Lead of DBAs in troubleshooting issues, performance tuning and implementation of best practices.
- Developed infrastructure as a code using Chef, PowerShell, Terraform, Team/Go City
- Built Lambda functions to automate cross region availability, backup management, instance maintenances in AWS
- Optimized data warehousing processing and analyses by implementing vertical indexing and read isolation
- Drastically improved performance of applications by tuning indexes and optimizing queries
Sr. SQL Server DBA / Architect
Responsibilities:
- Responsible for highly transactional SQL server databases supporting mobile and kiosk ordering
- Optimized logical and physical database design improving performance and transactional throughput
- Provided technical leadership in multiple efforts to design, implement, and support, enterprise projects covering performance, reliability and security.
- Implemented monitoring procedures to maximize availability and performance of the database, while meeting SLA's.
- Implemented High Availability and Disaster recovery solution ensuring minimal impact to performance while protecting data in case of disaster.
- Responsible for all SQL Servers serving core fleet leasing and management
- Designed logical and physical telematics databases storing millions of disappoints daily
- Lead capacity planning, hardware replacement and system upgrades efforts
- Team lead in troubleshooting issues, performance tuning and implementing best practices.
- Designed and implemented Always On and high availability
- Managed complex SQL Server environment involving set up, configure and administer Always-on, Replication, Mirroring and Clustering
- Developed a process of segregating database services
- Migrated large database services to Amazon AWS.
- Designed and implemented AlwaysOn and availability zones on AWS.
- Created PowerShell scripts for maintenance and data import / export to S3 on AWS
- Provide solutions to improve performance, establish high availability, and auditing
- Designed monitoring solution to ensure Microsoft SQL Server Servers are up and running 24x7
Confidential, New York
Manager, Database AdministrationResponsibilities:
- Oversee on-call production support and supervise a team of 6 DBAs and developers
- Develop operational plans and budgets in accordance with company goals and policies
- Gather requirements, generate estimates, and administer change management
- Implement disaster recovery, business continuity, and global server load balancing solutions
- Initiate SAN storage configurations and created Table partitions based on Date ranges
- Set up transactional replication and database mirroring for DR environments
- Using SSIS and DTS to implement ETL process and import data to databases
- Migrate and upgrade SQL databases while consistently monitoring SQL server performance
- Establish documentation standards and processes to help increase productivity