Home

Mayank - Database administrator

[email protected]

Location: Atlanta, Georgia, USA

Relocation: No

Visa: GC

Objective: Understanding the needs of internal and external stakeholders to deliver solutions through my management and technical expertise in database technologies, including design, administration, development, programming, architecture, and reporting. My background spans OLTP, ETL, OLAP, Big Data, and NoSQL applications, both on-premises and in cloud environments (Azure, AWS). Summary: Over Nineteen years of experience Installing, Configuring and Maintaining SQL Server. Worked with versions 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 on on-premise Physical, Virtual(VM) as well as Azure SQL Servers Extensive experience with designing logical and physical data model for VLDB using PowerDesigner/ Erwin(5+ years) Experience Creation and maintenance of databases, creating roles and managing user permissions, Backup and Restore activities, Resolving Deadlocks and optimizing complex queries and trouble-shooting problems. Extensive experience configuring and supporting advanced technologies like Clustering, Mirroring, Always On, replication and log shipping. Provided secondary level support to Oracle databases (9i/10g). Programming and performance tuning in PL/SQL, T-SQL. Created triggers, stored procedures, functions and packages. Wrote custom scripts and DTS/SSIS/SQL Data tools packages for ETL processes using ANSI SQL, T-SQL, VBScripts, VB.NET, and C #. Experience working with .net applications. Wrote scripts using PowerShell. Experience configuring various monitoring solutions such as Site-Scope, Orion and MOM Experience managing high volume OLTP databases in a high availability, 24 x 7 operating environment. Proficient creating, implementing, maintaining, assigning roles and security suites in IBM (DataStage), and MSBI suites-SSIS/SSRS/SSAS. Expert in creating reports using Business Objects and SSRS Follows Kimball groups design principles in dimensional modelling. Experience with Dimensional modelling ROLAP/MOLAP/HOLAP Involved in software life cycle analysis, development, planning and maintenance. Helped BI s analyze data using Power Pivot and Power View. Integration of warehouse system from relational databases (Oracle/MSSQL/FoxPro, Ingres(Unix based), MySQL) SFTP(Secure file transfer), FTP and various web services Followed both waterfall methodology and Agile based approach during development process. Experience in complete life cycle development in data warehouse environments. Installation, configuring VMWare Esxi 5.5 Experience with non-relational databases like MongoDB. Keywords: cprogramm business intelligence procedural language